Data transformation expressions 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.

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.