check a field value is not null in derived transformation in dataflow

Peruka, Sikander reddy 90

I am checking if a field(column) has data that is not NULL.

How do i use NOT ISNULL(field1) in derived transformation ?

I want to convert following code in derived transformation

example: iif( not isNULL(field1), field1, iif( not isnull(field2), field2, NULL)

Peruka, Sikander reddy 90 Reputation points

2024-07-10T03:29:16.0333333+00:00

Thanks

Accepted answer

Bhargava-MSFT 31,121 Reputation points Microsoft Employee

2024-07-09T20:58:30.69+00:00

Hello Peruka, Sikander reddy

Please try the below expression.

iif(isNull(field1) == false(), field1, iif(isNull(field2) == false(), field2, null()))
Please sign in to rate this answer.

1 person found this answer helpful.
Bhargava-MSFT 31,121 Reputation points Microsoft Employee

2024-07-10T14:30:01.0366667+00:00

Hello Peruka, Sikander reddy,

If this answers your question, please consider accepting the answer by hitting the Accept answer and up-vote as it helps the community look for answers to similar questions.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

0 additional answers

Your answer