How to filter more than one value in excel

datatable
excel
activities

#1

I am working on the following process where the robot first reads a range of cells from a file and stores them in the same variable, then those values must be filtered to another file. The question is how to filter with a variable that has more than one value (eg, 12,000, 18,000, 20,000). The variable “Objectives” has more than one stored value

how filter.xaml (12.2 KB)

Libro1.xlsx (3.0 MB)

OBJETIVOS Y COEFICIENTEL DE MUNICIPALIDADES.xls (47.5 KB)


#2

HI @Braki,

Please refer the below xaml files to filter more the one value.

FilterTableExample.xaml (6.9 KB)
ExcelTable.xlsx (9.7 KB)

another method to filter the data:
instead of excel filter activity you can use read range to get the all the data(dtresult-DataTable).
after that you can filter using select statement
dtresult=dtresult.select("[columnname] in (‘A’,‘B’)")

Regards,
Arivu


Sort ascending or Descending with out using tables