How to filter non blanks in excel

[PrankurJoshi]

This might help you

yourDataTable.Select(“YourColumnName=”“”)

yourDataTable.Select(“YourColumnName<>NULL”)

I need to filter datatable for blanks

I have a datatable that has a status column. This column starts blank and once the first action is taken it is marked as found or not found. I want to be able filter the status column by blanks/null/empty but have been unsuccessful so far. i am using dtInvoiceNum.Select(“Status=Null”) to create an array of datarows and then doing a for each in the array.

I need to filter out the blank from datatable which column is datetime type

My Excel file data show below [image] Then I do read range to keep data into DT1 variable datatable type (with header selected) And I do read cell to get column name of column 2 which is datetime type, it is 12-May-18. Keep into Header variable string type I have created the datarow type variable called DTrow1 After that I use Assign activity to do select datatable, propose to remove row 4 and 5 because of it contain blank data. I assigned DTrow1 in the left side and DT1.Select(Header+" <>‘…

Thanks,
Prankur