Map functions in mapping data flow

APPLIES TO: Azure Data Factory Azure Synapse Analytics

Tip

Try out Data Factory in Microsoft Fabric, an all-in-one analytics solution for enterprises. Microsoft Fabric covers everything from data movement to data science, real-time analytics, business intelligence, and reporting. Learn how to start a new trial for free!

Data flows are available both in Azure Data Factory and Azure Synapse Pipelines. This article applies to mapping data flows. If you are new to transformations, please refer to the introductory article Transform data using a mapping data flow.

The following articles provide details about map functions supported by Azure Data Factory and Azure Synapse Analytics in mapping data flows.

Map function list

Map functions perform operations on map data types

Map function	Task
associate	Creates a map of key/values. All the keys & values should be of the same type. If no items are specified, it's defaulted to a map of string to string type. Same as a [ -> ] creation operator. Keys and values should alternate with each other.
keyValues	Creates a map of key/values. The first parameter is an array of keys and second is the array of values. Both arrays should have equal length.
mapAssociation	Transforms a map by associating the keys to new values. Returns an array. It takes a mapping function where you can address the item as #key and current value as #value.
reassociate	Transforms a map by associating the keys to new values. It takes a mapping function where you can address the item as #key and current value as #value.

Related content

• List of all aggregate functions.
• List of all array functions.
• List of all cached lookup functions.
• List of all conversion functions.
• List of all date and time functions.
• List of all expression functions.
• List of all metafunctions.
• List of all window functions.
• Usage details of all data transformation expressions.
• Learn how to use Expression Builder.