ADF and @Equal Expression

Mike Kiser 1,536 Reputation points
2021-02-15T01:39:31.637+00:00

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.
9,933 questions
0 comments No comments
{count} votes

Accepted answer
  1. Nasreen Akter 10,766 Reputation points
    2021-02-15T02:13:55.683+00:00

    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