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 InputIDNameColor1RaviBlue2KumarBlue3RajBlue4AnuBlue5KarthikBlue6VinodGreen7JohnGreen8MathewGreen9MageshGreen10ChackoGreen11HussainGray12SandyGray13BalaGray14SenthilGray15MonaGray Output 1IDNameColor1RaviBlue2KumarBlue3RajBlue4AnuBlue5KarthikBlue Output 2IDNameColor6VinodGreen7JohnGreen8MathewGreen9MageshGreen10ChackoGreen Output 3IDNameColor11HussainGray12SandyGray13BalaGray14SenthilGray15MonaGray

Different output required based on the condition

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

Workflow

Datasets

Reporting

Output

Custom Tools

Data Investigation

Accepted answers

Amol_Telore

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.

New Workflow3.yxmd

All comments

Amol_Telore

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.

New Workflow3.yxmd

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/ta-p/951995

ravikumar060987

Thank you for the update.

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

Thank once again.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

AdamR 335