Data Split by column values

[Rashmigangadhara]

Hi ,

I`m looking for the dynamic filtering of the data set by one of the column values present in that data.

Eg : In the below data set I have data by Region, I need to split this data by region dynamically , and need that divided data sets for further analysis.

 Input Data

Unique ID	CoCd	Tower Name	Team Name	Region
100	10	TowerA	Finance	Region1
200	20	TowerA	Finance	Region1
300	30	TowerB	Procurement	Region2
400	40	TowerC	Finance	Region2
500	50	TowerD	HR	Region3
600	60	TowerA	Supplychain	Region3
700	70	TowerB	Supplychain	Region4
800	80	TowerC	Finance	Region4

Expected output :

Unique ID	CoCd	Tower Name	Team Name	Region		Unique ID	CoCd	Tower Name	Team Name	Region
100	10	TowerA	Finance	Region1		500	50	TowerD	HR	Region3
200	20	TowerA	Finance	Region1		600	60	TowerA	Supplychain	Region3
Unique ID	CoCd	Tower Name	Team Name	Region		Unique ID	CoCd	Tower Name	Team Name	Region
300	30	TowerB	Procurement	Region2		700	70	TowerB	Supplychain	Region4
400	40	TowerC	Finance	Region2		800	80	TowerC	Finance	Region4

With the current options, I will have to add the filters manually based on the number of regions , I want solution where I can replace this manual filter addition and even if more regions added in data that should be taken care dynamically.

Thanks

[AndrewDMerrill]

It looks like you are just outputting each subset of data to its own file. This can all be done with a single Output Tool. Simply use the Formula Tool to create a new column labeled "File Path", which you can set to:

".\"+[Field1] + "Data.xlsx|||Sheet1" or whatever you want the file path to be.

[AndrewDMerrill]

I just saw that this same question was already asked and answered here:

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Data-Split-by-Column-Values/td...