Remove rows containing 0 or blank

[Soniya215 (Soniya)]

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

[ImPratham45 (Prathamesh Patil)]

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

[Lahiru.Fernando]

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

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

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

[ImPratham45 (Prathamesh Patil)]

For Ref

[Soniya215 (Soniya)]

Thanks a lot for the help