Skip to main content
Use this mapper to pull one field out of every item in a list and collect those values into a single, flat result. For example, from a list of order lines you can grab just the product names, or from a list of customers just their email addresses. You can also choose which field to use as the key for each value, so the result becomes a lookup table instead of a plain numbered list.

​
Fields

​
Sample data

This example reads the product name from each order line and keys each name by its SKU.
FieldValue
Column keyname
Index keysku
Input: 
[
    { "sku": "SCARF-01", "name": "Wool scarf", "qty": 2 },
    { "sku": "BELT-02", "name": "Leather belt", "qty": 1 }
]
Output: 
{
    "SCARF-01": "Wool scarf",
    "BELT-02": "Leather belt"
}
Leaving the Index key empty would instead give a numbered list of names, ["Wool scarf", "Leather belt"].