Function in adf

Question

Hi what are the functions in adf Pls help me with screenshots

Accepted Answer

In case if there is need for any dynamic values or some transformations, you can use functions within ADF :

User's image

There are diff types of functions and the below doc explains all those in details :

https://video2.skills-academy.com/en-us/azure/data-factory/control-flow-expression-language-functions

Answer

Hi @Vineet S
Thank you for your question and using the Microsoft Q&A platform.
Azure Data Factory (ADF) supports a wide range of functions that can be used in expressions. Here are some of the categories of functions supported by ADF:

String Functions: These functions perform operations on string data types. They include functions like concat, replace, split, length, etc.
Conversion Functions: These functions are used to convert data from one type to another.
Date Functions: These functions are used to manipulate and format date and time values.
Logical Functions: These functions perform logical operations and include functions like and, or, not, etc.
Math Functions: These functions perform mathematical operations.

Please refer to the below related documents for more help:
https://video2.skills-academy.com/en-us/azure/data-factory/control-flow-expression-language-functions
https://video2.skills-academy.com/en-us/azure/data-factory/how-to-expression-language-functions

In the below screenshot, I have selected the "Length" function. It returns the number of items in a string or array.
User's image

Hope this helps. Do let us know if you any further queries.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Share via

Function in adf

1 additional answer

Your answer