I would like to use IS NOT NULL in synapse's dataflow, but I can't get it to work. Can you please tell me how to do it? I have also tried notNull, but it doesn't work... I used the dataflow filter.

Hi @NishimuraChinatsu-9854 , Thank you for posting query in Microsoft Q&A Platform. You can use expression as !isNull(<value/column>) to evaluate not null values. Please check below screenshot for better understanding. Hope this helps. --------- Please consider hitting Accept Answer button. Accepted answers help community as well.

How to use IS NOT NULL in synapse dataflow

Accepted answer

ShaikMaheer-MSFT 37,896 Reputation points Microsoft Employee

2022-12-20T10:16:05.923+00:00

Hi @NishimuraChinatsu-9854 ,

Thank you for posting query in Microsoft Q&A Platform.

You can use expression as !isNull(<value/column>) to evaluate not null values.

Please check below screenshot for better understanding.

Hope this helps.

---------
Please consider hitting Accept Answer button. Accepted answers help community as well.
Please sign in to rate this answer.

2 people found this answer helpful.
NishimuraChinatsu-9854 756 Reputation points

2022-12-21T06:59:41.043+00:00

Yes, it can. Thank you.

Javid Ali Khan Lavani 0 Reputation points

2024-04-19T12:06:56.6766667+00:00

@ShaikMaheer-MSFT its not working any other way?
i have a column containing date values and nulls i need to ignore null values and have to pick only rows that contains dates.
used this !isNull({columnname}) Does it only work for the strings?
Sign in to comment

How to use IS NOT NULL in synapse dataflow

0 additional answers