Different output required based on the condition
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 |
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you for the update.
I don't know - how I forgot this option in Alteryx.
Thank once again.