split file based on comma separated column

Question

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 Answer

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 Answer

Hi, @smrithiraj

FYI.