Splitting data into multiples files/outputs based on column value

I have a large amount of data that I need to split into different files/outputs. One column contains 1 of 7 values, so I want to split the data into these 7 categories.

What would be the best way to do this?

Ideally these outputs will be into QVX files so I can go ahead and visualise in Qlik.

Thanks in advance.

Output

Accepted answers

DataNath

Hey @SamThomas, as you've mentioned you want your outputs to be .QVX files, just choose that and set a FileName, then you can use one of these options to differentiate your 7 files, selecting the Field containing your 7 values as the 'Take File/Table Name From Field':

Here's an example of outputting to a bunch of files with the field suffixed to the core FileName:

All comments

ShankerV

Hi @SamThomas

Hope you are expecting the output like this where all 7 categories are in different sheets.

The below setting in the Output tool, helps to achieve.

Splitting data into multiples sheets.yxmd

Test 21022023.xlsx

DataNath

Here's an example of outputting to a bunch of files with the field suffixed to the core FileName:

SamThomas

Thanks for your response. This worked as expected. The only very slight issue is that when it creates the filenames, it doesn't leave a space between the name and value. So it structures it like this WORKFLOWNVALUE.qvx. Do you happen to know how I might be able to add a separator?

DataNath

Hey @SamThomas, great to hear! For this, I'd actually just make my filenames in a formula like so:

Where 'Test' is whatever you want the 'core' filename to be, and then referencing the field with your 7 values where I currently have [Name]. Once you come to the Output Data tool, you then reference this custom field and choose 'Change File/Table Name' from the dropdown. This will then completely replace whatever you set up in the configuration originally, hence why I have just used 'dummy.qvx':

When you run that:

Workflow attached for your reference, hope this helps!

Split to multiple QVX files.yxmd

SamThomas

Great, thanks again. Much appreciated.

Jodie_sam

Hi There,

I wanted to split my data into multiple tabs into one output by a column value names, your solution works perfect. The only challenge I am facing is the sheet names Alteryx creating has a prefix to it, for e.g sheet1A and I would need only A,B,C (as in individual tabs) instead Sheet1A,Sheet1b, Sheet1C. Could you please help with this?

Many thanks.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703