We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Splitting the data to separate streams

Wojtek_Dz
8 - Asteroid

Hi, 

 

I just wondering is some faster solution to split data to several streams by values from selected column except filter tool ??

 

Input:

 

Wojtek_Dz_0-1631108201292.png

 

Expected output

Wojtek_Dz_1-1631108248006.png

 

Wojtek_Dz_2-1631108267441.png

 

Wojtek_Dz_3-1631108285815.png

 

 

Current solution: 

Wojtek_Dz_4-1631108516965.png

(please ignore errors)

5 REPLIES 5
atcodedog05
22 - Nova
22 - Nova

Hi @Wojtek_Dz 

 

Can you provide more info on the usecase. Is it a limited number of Names?

Wojtek_Dz
8 - Asteroid

Sure, so this is large dataset, with column with name who putting each line it to the sheet. e.g. in name column there is 15 unique names, and I would like to split this whole dataset for 15 separated streams

atcodedog05
22 - Nova
22 - Nova

Hi @Wojtek_Dz 

 

Yes, what you are doing is the right way. Can I know why you need to split into streams ?

Wojtek_Dz
8 - Asteroid

I need to split in to streams, because I want to do calculations for each stream, save it as separate file etc 🙂

dougperez
12 - Quasar

You can do the calculations and save the data into different files in one stream, see the workflow attached

Labels
Top Solution Authors