Share via

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

Peruka, Sikander reddy 155 Reputation points
2024-07-09T17:16:30.26+00:00

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)

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,373 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,624 questions
Accepted answer
  1. Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator
    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()))

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.