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 |
Solved! Go to Solution.
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.
@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.
Alteryx 2019.2 x64 is the version (.yxmd)
@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.
Thank you so much , it worked!
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! :)
hi,
This really worked. I got three different files :) Thanks a lot
@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!