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

2023-05-16T12:28:31.8633333+00:00

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

Begin

statements

end

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
    2023-05-18T04:31:20.34+00:00

    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.

    @not(empty(variables('varValue')))
    
    

    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