check if the value is a number and output in iif logic of derived transformation

Question

I am checking if the input value is a number then output as '100' else 'invalid' in derived transformation in dataflow.

In the documentation, I found 'isLong' function. But, how do we use this function in an iif statement.

https://learn.microsoft.com/en-us/azure/data-factory/data-flow-expressions-usage#islong

The following code isn't working.

iif(isLong(column1),'100','Invalid')

Answer 1

Hi @Peruka, Sikander reddy

Thanks for the question and using MS Q&A platform.

To check if the input value is a number and output '100' if it is, and 'invalid' if it is not, you can use the isLong function in an iif statement in the derived transformation in data flow.

The syntax for using isLong function in an iif statement is correct. However, the issue might be with the input column. Please ensure that the input column 'column1' is of string data type.

Here is the correct expression of how to use the isLong function in an iif statement:

iif(isLong(toString(column1)),'100','Invalid')

The toString function is used to convert the input column to a string data type, which is required for the isLong function to work correctly.

I hope this helps! Let me know if you have any further questions.