To select Column with null values

[lissynikkytha]

Hi,

How do we select the rows whose customer number column is null or blank spaces?

Say for example, Column B is Customer number. I need to select the rows which has null or blank space in that column and need to process those rows inside For each loop. Syntax DT.Select(“[Customer Number]=”+“”) throws error. Please help me with this.

[aksh1yadav (AKSHAY YADAV)]

@lissynikkytha

How do we select the rows whose customer number column is null or blank spaces?

Delete data row from data table

this statement returning the rows which are having status ‘PV’. so you have to modify it something like this for your requirement DataTable.Select(“[COLUMN 1]=‘’ OR [COLUMN 2]=‘’”) and if null values you have then you can use like this: DataTable.Select(“[COLUMN NAME] is null”); and then you can easily inside for each loop ,can use Remove data row activity. Regards…!! Aksh

Regards…!!
Aksh

[lissynikkytha]

Thank you. It worked.