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

Anonymous
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.
11,495 questions
{count} votes

2 answers

Sort by: Most helpful
  1. QuantumCache 20,356 Reputation points Moderator
    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


  2. Bongo 21 Reputation points
    2024-07-28T15:34:30.78+00:00

    Good Day

    I am also not finding joy with. ["@not(empty())"].

    Is there something I am missing.

    0 comments No comments

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.