Looping through each record in a field

[iqkh76]

I am trying to loop through each record in a field and filter data from ano input based on the criteria from each record.to a tab in an Excel file.

For e.g.

Output from one the data table is 

Name

A

B

C

I need to loop through the records and filter data for each record i.e. A, B, C

Something similar to For each record filter another dataset and copy the filtered data to an Excel file with Tab A, Tab B, Tab C and so on.

[IraWatt]

Hey @iqkh76,

There is a fantastic article on how to do this on the community here:

Dynamic Filter filtrer filter (alteryx.com)

[Qiu]

@IraWatt 
Nice one!

[binu_acs]

@iqkh76 one way of doing this with the help of batch macro as mentioned like @IraWatt . I included the rest of the requirement in the attached workflow