Is there any way to do isnull and whitespace in Filter Data Table?

Yes you are right
For now we have got only IsEmpty as a filter option in FILTER DATATABLE activity
Hope In future release it will come

But still you can try like this
Use operator = and in value mention as Nothing

Or

for this scenario we can simply use a assign activity with a expression like this

Dt = Dt.AsEnumerable().Where(Function(a) String.IsNullOrEmpty(a.Field(Of String)(“column name”).ToString) ).CopyToDatatable()

It does the same what you expecting

If you need for multiple columns to be validated then the expression will be like

Dt = Dt.AsEnumerable().Where(Function(a) String.IsNullOrEmpty(a.Field(Of String)(“columnname_1”).ToString) AND
String.IsNullOrEmpty(a.Field(Of String)(“columnname_2”).ToString) ).CopyToDatatable()

Cheers @Kirigirisu_Coin

1 Like