Data transformation expressions in mapping data flow

APPLIES TO: Azure Data Factory Azure Synapse Analytics

Data flows are available in both Azure Data Factory pipelines and Azure Synapse Analytics pipelines. This article applies to mapping data flows. If you're new to transformations, refer to the introductory article Transform data using mapping data flows.

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.

Related content

Learn how to use Expression Builder.