UnFilter data on Blank and 0

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

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

image

1 Like

I doubt it will work for null value

@md.ahtesham,

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

1 Like

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.

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