How to handle Null in a Logical Expression ADF - Another PROD Issue

Mike Kiser 1,536 Reputation points
2021-06-18T14:05:40.533+00:00

Hello @Nasreen Akter @MartinJaffer-MSFT @KranthiPakala-MSFT

I have a simple expression in my If Activity where I need to say

If @equals(item().grandfatheredPension,Null)

But the NULL isn't working. There are null's in the DB Table for this value and I need to trap the ones for the IF Activity.

Please help! Another Production issue...
THanks
Mike Kiser

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

Accepted answer
  1. Nandan Hegde 36,151 Reputation points MVP Volunteer Moderator
    2021-06-18T14:38:13.543+00:00

    Hey,
    You can use coalesce function.
    https://learn.microsoft.com/en-us/azure/data-explorer/kusto/query/coalescefunction

    somewhat like the below:
    IF @equals(coalesce(item().grandfatheredPension,''),'')

    1 person found this answer helpful.

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.