Excel Automation Filter data table


I am trying to remove more than two numeric values from two different columns simultaneously, but am unable to remove those values. Need some assistance on this. Below are the screenshots and workflow.

Note : I need to filter 0,1,2,3,4,5,59,64 and 269 from one column and simultaneously i need to select 0,1,2,3,4,5,59 and 269 from the second column and delete both at the same time.


Thanks in advance

I’m not sure I understand what you want to do, but you can specify the values you want to filter out by adding them to the conditions.
For example, if you want to remove all rows that have a 59 in the first column along with all rows having 269 in the second column, then you need to specify a remove condition like Column1 = 59 OR Column2 = 269.

If you have many numbers to filter, then it’ll probably become a bit difficult to maintain everything using the Filter DataTable activity’s interface. In this case, it might be a better idea to use the Select method to filter your table.

Samples of both approaches: FilterDataTableExample.zip (21.1 KB)

1 Like

Thank you :slight_smile: