| title | Data Transformation Functions in the Mapping Data Flow |
|---|---|
| titleSuffix | Azure Data Factory & Azure Synapse |
| description | Learn about data transformation functions in mapping data flows. |
| author | kromerm |
| ms.author | makromer |
| ms.subservice | data-flows |
| ms.custom | synapse |
| ms.topic | reference |
| ms.date | 05/15/2024 |
[!INCLUDEappliesto-adf-asa-md]
[!INCLUDEdata-flow-preamble]
By using data transformation expressions in Azure Data Factory and Azure Synapse Analytics, you can transform expressions in many ways. They're a powerful tool that you can use to customize the behavior of your pipelines in almost every setting and property. You can use them anywhere you find a text field that shows the Add dynamic content or Open expression builder links within your pipeline.
The following articles provide details about expressions and functions supported by Azure Data Factory and Azure Synapse Analytics in mapping data flows:
- Aggregate functions
- Array functions
- Cached lookup functions
- Conversion functions
- Date and time functions
- Expression functions
- Map functions
- Metafunctions
- Window functions
For details about the use of each function in a comprehensive alphabetical list, refer to Usage details of all data transformation expressions.