question

ewinkiser avatar image
0 Votes"
ewinkiser asked ewinkiser commented

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

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

NandanHegde-7720 avatar image
0 Votes"
NandanHegde-7720 answered ewinkiser commented

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

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

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Perfect, @NandanHegde-7720 !!

It worked the first time!!

Thanks!!
MIke Kiser

0 Votes 0 ·