Filter out unwanted values in Excel file

Hello guys,
Can you suggest the best way how to simply “filter out” unwanted values from excel file ?
Is “Filter table” activity suitable for this ?

Thank you

Per my knowledge, you can use the Filter Table activity to only filter so that a particular value remains in the table. Not to ‘filter-out’ certain values:

Alternatively, you could consider the Filter Data Table activity. Use the ‘Remove’ option and configure it accordingly.



There is a Datatable activity in uipath path known as filter Data table.
Follow these points:

  1. Use read range to read your excel file.
  2. then use filter data table and u can remove values which you don’t need.
  3. Lastly, use write range activity.

Hope , this helps you.

Thanks and regards
Sahil garg

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