Share via

ADF and @Equal Expression

Mike Kiser 1,536 Reputation points
Feb 15, 2021, 1:39 AM

Hello
I have the following values in the DB as a bit datatype
[grandfatheredPension] [bit] NULL,

When I do an ADF Lookup I get the following: 67860-image.png
for the grandfatheredPension value

THEN, I use an IF Condition and have the IF Activity Expression as 67848-image.png

67941-image.png

MY ISSUE is that the value stored as a 1 in the grandfatheredPension field in the DB NEVER Drops in the True Activity of the If Condition. I have tried everything that I can think of.

Can you please assist?
Thanks!
Mike

@Nasreen Akter @MartinJaffer-MSFT

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,936 questions
0 comments No comments
{count} votes

Accepted answer
  1. Nasreen Akter 10,796 Reputation points
    Feb 15, 2021, 2:13 AM

    Hi @Mike Kiser ,

    The equation you have i.e., @equals(item().grandfatheredPension, true) looks good to me. In your pipeline if you have a LOOKUP then FOREACH and then IF, it should work. From your description you did not mention about a for-loop. would you please clarify. Thanks!

    0 comments No comments

0 additional answers

Sort by: Most helpful

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.