How to use IS NOT NULL in synapse dataflow

Question

NishimuraChinatsu-9854 756

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.

0 comments

Answer accepted by question author

0 additional answers

Answer 1

ShaikMaheer-MSFT 38,631 Microsoft Employee Moderator

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.

NishimuraChinatsu-9854 756 Reputation points

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

Yes, it can. Thank you.
JavidAliKhanLavani-6510 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?
Kit MacInnes-Manby 20 Reputation points

2026-07-16T13:03:54.9866667+00:00

Pointing out that this solution doesn't actually appear to be documented anywhere, so it would be good to add it to the documentation. For example here would be good (similar to how it is documented for notEquals).

https://learn.microsoft.com/en-us/azure/data-factory/data-flow-expression-functions