How to get null values from excel column

Hi All,

I have excel i need to pick only null values from “Address” Column how to do that i used filter database and select query its not working.

Please help.01_22_2020.xlsx (2.8 MB)

What Problem U are facing?01_22_2020.xlsx (2.8 MB) Flowchart3.xaml (8.3 KB)

Hi @thima

What Error you are facing

Dt.Select(“[Address]<>‘’”).CopyToDatatable()
or

Dt.Select(“[Address]=‘’”).CopyToDatatable()

Thanks
Ashwin S

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.