How to split an excel to multiple excels based on the Labeler number

[Sunithaprdp]

Hi, 

How can we split an excel to multiple excel files based on a criteria.

This is the data in one excel worksheet. I want to split this excel to three excel workbooks based on the labeler. For eg: 00012 data should be in one excel , similarly 00023 and 00043 in different excel workbooks. How can we do that ? Can you please help me?

state	labeler	amount	year
a	00012	100	22022
b	00012	200	22022
c	00012	300	22022
d	00012	400	22022
e	00012	500	22022
f	00023	600	22022
g	00023	700	22022
h	00023	800	22022
i	00023	900	22022
j	00023	1000	22022
k	00023	1100	22022
l	00043	1200	22022
m	00043	1300	22022
n	00043	1400	22022
o	00043	1500	22022

[Sunithaprdp]

I am not sure why I am unable to import the workflow? Is it because of the old version that I am using? Even I am not able to upload the macro.

[DataNath]

@Sunithaprdp what have you tried for importing it, just right click > insert > macro? And that's not working?

What version # are you using? I can save a copy as that and we can see if it works if it's really old.

[Sunithaprdp]

Alteryx 2019.2 x64 is the version (.yxmd)

[DataNath · Accepted solution]

@Sunithaprdp I've edited the XML of this to make it 2019.2 - let me know if you're still running into issues though I'm not sure this will be the cause.

[Sunithaprdp]

Thank you so much , it worked!

[DataNath]

No problem @Sunithaprdp - if you could mark the correct solution then that'd be great so others with the same issue can easily find it in future! :)

[Sunithaprdp]

hi,

This really worked. I got three different files :) Thanks a lot

[r_gratz]

@DataNath  I have really ugly excels with multiple tables on 1 sheet (but also each table starts on different row), for this reason I'd like to split it vertically rather than horizontally. Is there a way to do that in Alteryx? Thank you!

[Jodie_sam]

Hello @binuacs,

Your solution given here worked very fine for me and I wanted to split my data by Product_type which is 19 different products into 19 separate excel files, exactly like how I wanted it to be. thanks a lot