how to pass value as not null in the ADF pipeline variable in if condition


how to pass value as "is not null" in the ADF copy activity and how to build the expression in if condition?

ex: if @value is not null




Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,906 questions
{count} votes

1 answer

Sort by: Most helpful
  1. QuantumCache 20,106 Reputation points

    Hello @Bommisetty, Rakesh (Hudson IT Consultant)

    Please have a look at the below pipeline, hope it helps with you initial Query!

    I have created a Pipeline Variable called 'varValue'

    I am verifying the Null Value in the 'If Condition' and then i have added Activity based on the expression result.


    User's image

    Inside the 'If Condition'-->Copy Data-->Query as shown below.

    select * from dbo.employeeSource where City!='@{variables('varValue')}'

    IF the Condition is True then the True Activity will be executed and and the Query is again using the Pipeline Variable as shown below.

    User's image