How to Split a huge file into multiple ones based on column

Hi, I have a huge consolidated file and I need help splitting them into multiple smaller files based on the column content.

The column content is having A,B,C....

I need to split it into file A with this column filtered on A, file B with this column filtered on B, etc.

How should i create a workflow, thanks.

Workflow

Accepted answers

RolandSchubert

Using your sample files, I modified the workflow a bit, result are Excel files now.

SplitFile.yxmd

atcodedog05

Hi @rachelzhou

Here is how you can do it.

1st generate the filename with full path like below. If file is not specified file will be outputted to the folder where the workflow was.

2nd configure the output to create new file for each filename by configuring like below.

Hope this helps : )

split into files.yxmd

Output-codale.xlsx

Output-Crawford.xlsx

Output-Cooper.xlsx

All comments

atcodedog05

Hi @rachelzhou

Can you provide some sample input and expected output It will help us get a better understanding of the usecase.

We will be happy to help : )

RolandSchubert

Hi @rachelzhou ,

what do you think about this solution:

You create the full filename (including path and extension) using a formula tool and set the option to take the output file name from a field. All filtering is done by the output tool!

Let me know if it works for you.

Best,

Roland

SplitFile.yxmd

rachelzhou

For example, in input file first column "name" have capital, codale, cooper, etc.. output file is selected based on the names, capital as an example and i need to do the same for rest of the names. Thanks.

Alteryx Input.xlsx

Alteryx output- Capital.xlsx

saveeshkumar

Hi @rachelzhou ,

Please find the workflow.

Thanks

Alteryx_Output.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703