Multiple sheet creation with filter logic

[sn2200]

Hi,

I have an excel file with over 50 fields where from the 25th field i need to filter out No from each field then create a new sheet in excel and rename the sheet name with the same 25th field name. What is the best way to get it done in alteryx?

In the Sample data below, i need different sheets created from the field names G7-M13 and with their same sheet name as the field name but only the Y on the particular field name. In the output sample, in G7 field only Y is selected and same output needs to be saved in a sheet where the sheet name is G7.

A1

B2

C3

D4

E5

F6

G7

H8

I9

J10

K11

L12

M13

Sample

Sample

Sample

Sample

Sample

Sample

Y

Y

N

N

Y

Y

Y

Sample

Sample

Sample

Sample

Sample

Sample

N

N

N

N

N

N

Y

Sample

Sample

Sample

N

Y

Y

Y

Y

N

Y

Sample

Sample

Sample

N

Y

N

N

N

N

N

Sample

Sample

Sample

Sample

Sample

Sample

Y

N

Y

N

N

N

Y

Sample

Sample

Sample

Sample

Y

N

N

Y

N

Y

N

Sample

Sample

Sample

Sample

Sample

Sample

N

N

N

N

N

N

N

Output Sample: 

A1

B2

C3

D4

E5

F6

G7

H8

I9

J10

K11

L12

M13

Sample

Sample

Sample

Sample

Sample

Sample

Y

Y

N

N

Y

Y

Y

Sample

Sample

Sample

Sample

Sample

Sample

Y

N

Y

N

N

N

Y

Sample

Sample

Sample

Sample

Y

N

N

Y

N

Y

N

Thank you in advance. 

[caltang]

Like so?

[Raj]

The workflow suggested by @caltang will work but just add the join tool to join by record Id to bring all the Columns in the sheet else it will just display the standard Columns.

hope this help!

[caltang · Accepted solution]

Not sure if you really want that because the data is split based on what is "Y" and "N", but if you want to proceed, I've joined it for you here:

[sn2200]

Thank you so much @caltang !! really appreciate your support!