data-transformation-functions.md

title	titleSuffix	description	author	ms.author	ms.service	ms.subservice	ms.custom	ms.topic	ms.date
Data transformation functions in the mapping data flow	Azure Data Factory & Azure Synapse	Learn about data transformation functions in mapping data flow.	kromerm	makromer	data-factory	data-flows	synapse	conceptual	02/02/2022

Data transformation expressions in mapping data flow

[!INCLUDEappliesto-adf-asa-md]

[!INCLUDEdata-flow-preamble]

Data transformation expressions in Azure Data Factory and Azure Synapse Analytics allow you to transform expressions in many ways, and are a powerful tool enabling you to customize the behavior of your pipelines in almost every setting and property - anywhere you find a text field that shows the Add dynamic content or Open expression builder links within your pipeline.

Transformation expression function list

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 usage of each function in a comprehensive alphabetical list, refer to Usage details of all data transformation expressions.

Next steps

Learn how to use Expression Builder.