split file based on comma separated column

[smrithiraj]

Hello There!

I would like to know if there is a way to split the below file based on the values in "Subject ID". For example, Object ID = 1 will appear in 2 files as - File1 - "Object ID=1, Subject ID=10,20,30" and File2 - "Object ID=1, Subject ID=40,50" and correspondingly every other row... Basically we are splitting the the file and retaining just the first 3 values of Subject ID in each file against every Object ID.... Can we do this using Alteryx?

Thanks in advance for helping me out.

Regards

Smrithi

[gawa · Accepted solution]

hi @smrithiraj 

Yes, you can. You need to parse data into rows by Text to Column tool, and put a File ID(File1, FIle2,...), and output to each file.

For the ease of explanation, output format is CSV file in the attached WF. Pls change it to the format you want.

[flying008 · Accepted solution]

Hi, @smrithiraj 

FYI.