I am trying to use the Excel Filter activity to filter a single column in a spreadsheet. I need to filter for up to 10 different text values.
I’ve tried using multiple Filter activities, but each one seems to remove the previous filter.
I have attached a sample test file.
I would like to be able to use a For Each loop and to iterate through a list of names and apply a filter for each one. It’s important that I am able to pass in the list from an asset.
Any ideas?
Is it possible to write an advanced expression such as “Name1” and “Name2” in the Advanced Filter expression editor.
Hie @james.harvey if your Excel Column has multiple filter condition you can go with assign activity. use assign activity and create a datatable and write a linq query.
foe eq-
Assign
dtfilter(Datatable)-(
from row in dt1(yourinputdatatable)
where row(“yourcolumnname”) = “value” (Conditon) or there you can
add multiple condition)
Select.row
).copytodatatable
cheers Happy Automation
If the end goal is to read the data after filter…then instead read the data and then use filter datatable in a loop…that should give you the filtred range
