Different output required based on the condition

[ravikumar060987]

Dear All,

I have a situation where I have a large amount of data, approximately 10L rows. Sharing the sample now.

The problem is that I need to extract different output files from Alteryx based on the colour condition.

I understand that I can use the filter tool for each condition to extract one set of data, but if I start using the filter, the workflow will only contain the filter tool because I have so many conditions to extract different sets of data.

so please assist me in resolving this problem

Input
ID	Name	Color
1	Ravi	Blue
2	Kumar	Blue
3	Raj	Blue
4	Anu	Blue
5	Karthik	Blue
6	Vinod	Green
7	John	Green
8	Mathew	Green
9	Magesh	Green
10	Chacko	Green
11	Hussain	Gray
12	Sandy	Gray
13	Bala	Gray
14	Senthil	Gray
15	Mona	Gray

Output 1
ID	Name	Color
1	Ravi	Blue
2	Kumar	Blue
3	Raj	Blue
4	Anu	Blue
5	Karthik	Blue

Output 2
ID	Name	Color
6	Vinod	Green
7	John	Green
8	Mathew	Green
9	Magesh	Green
10	Chacko	Green

Output 3
ID	Name	Color
11	Hussain	Gray
12	Sandy	Gray
13	Bala	Gray
14	Senthil	Gray
15	Mona	Gray

[Amol_Telore · Accepted solution]

Hey @ravikumar060987 

Are you looking to generate different files for each color. Simplest way to do is append color field to file name in output tool.

[DataNath]

Hey @ravikumar060987 - are you trying to output to Excel? If so, I built a macro (link below) that will do this for you - you simply have to select whether you want the outputs as different files or different sheets within the same file. After that, you can select your field to split on (in your case it would be Color) and sit back whilst it runs. If you need any further help let me know. Other outputs I’d imagine you’ll just need to run the filter idea as you say but as a batch macro, proving your list of colours as the control parameter.

https://community.alteryx.com/t5/Public-Community-Gallery/Output-to-multiple-Excel-files-or-sheets/t...

[ravikumar060987]

Thank you for the update. 

I don't know - how I forgot this option in Alteryx.

Thank once again.