Data Table Filter in Loop

Help
1

Hi,

I want to filter my data table according to values of my excel and I want to write all result to another Excel.Thank you.Sequence10 - Copy (2).xaml (14.0 KB)

image
image534×755 14.6 KB

2

Okay, so your request is to write for each filter new Excel?
You are on good path, you just need Dynamical Output then, to save new Excel file for each filter pattern

3

Hi,

Yes. For example, for first row of excel, data table will give me an output and I want to write it another Excel. For second row of excel, data table will give me an another output and I want also to write it another Excel. I want to make it for all rows of Excel.

How can I do? Thank you.

4

Well you can make some kind of Counter, initialize it on 1, and increment it in each loop with Counter += 1.

In Write Range activity make Output + Counter.ToString, that way you will get different Excel file for every next filter