Function in adf

Question

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

Answer 1

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

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

https://learn.microsoft.com/en-us/azure/data-factory/control-flow-expression-language-functions

Answer 2

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:

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

Please refer to the below related documents for more help:
https://learn.microsoft.com/en-us/azure/data-factory/control-flow-expression-language-functions
https://learn.microsoft.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.

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.