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,''),'')
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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
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,''),'')