UnFilter data on Blank and 0

[md.ahtesham (Ahtesham)]

i am trying to write select query on data table where i can unselect 0 and Blank in the column, but i am not getting currect result…

Can someone please provide me this query ??

Thanks,
Ahtesham

[kaderms (Kader)]

You can try using FilterDataTable activity if you are not specific about writing a select query.

https://docs.uipath.com/activities/lang-en/docs/filter-data-table

[md.ahtesham (Ahtesham)]

I doubt it will work for null value

[Mohansadaiyapillai (Mohanraj S)]

@md.ahtesham,

You can add one condition that “columnname” is not empty in the filter datatable to skip the Blank field.

[Vashisht (Vashisht Devasani)]

Hi @md.ahtesham,

You can use the filter Data table like this…

This will remove the row which column contains the value 0 or null…

So, the rest is the required data table present in the dt1.

Cheers.
Vashisht.