| title | Map Functions in the Mapping Data Flow |
|---|---|
| titleSuffix | Azure Data Factory & Azure Synapse |
| description | Learn about map functions in mapping data flows. |
| author | kromerm |
| ms.author | makromer |
| ms.subservice | data-flows |
| ms.custom | synapse |
| ms.topic | concept-article |
| ms.date | 05/15/2024 |
[!INCLUDEappliesto-adf-asa-md]
[!INCLUDEdata-flow-preamble]
This article provides details about map functions supported by Azure Data Factory and Azure Synapse Analytics in mapping data flows.
Map functions perform operations on map data types.
| Map function | Task |
|---|---|
| associate | Creates a map of key/values. All the keys and values should be of the same type. If no items are specified, it defaults 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. The second parameter 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 the 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 the current value as #value. |
- 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.