Remove rows containing 0 or blank

I want to remove all the rows in my data table which contains “0” or “blank” cell in a column.
Thanks in advance.

Use Filter Datatable activity
In that use condition as ColumnName= “”
or
ColumnName=“0”
And use Remove option

You can use the Filter DataTable activity to filter out the values that are 0

  • use a read range acitivity to read the data to a datatable
  • next use this activity to filter out the unwanted rows.
1 Like

For Ref

1 Like

Thanks a lot for the help :slightly_smiling_face:

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