Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Spit output data into multiple excel files based on number of rows of output data

srk0609
8 - Asteroid

I want to have data into either 1 excel file or split into multiple excel files based on no.of rows of data. If the output data is 75000 then I should get 1 file but if it is 1 lakh then there should be 2 files 
1 - File 1 containing 75000
2 - File 2 containing 25000

If there are 2 lakh records
1 - File 1 containing 75000

2 - File 2 containing 75000

3 - File 3 containing 50000 

 

I already added RecordID tool to create block based on number of records.

I'm getting "You  must specify a sheet name Error". It would be great if someone could help share the workflow and steps to build it. Thank you.

4 REPLIES 4
srk0609
8 - Asteroid

Thank for the Links but none of the links have a accepted solution. Is there anything else that I can refer? Please let me know. Thank you.

Colman_Hendershot
6 - Meteoroid

@srk0609 ....Following @Luke_C 's links I was able to replicate a potential solution. See below. 

 

alteryx answer pt 1.pngScreenshot 2024-12-11 164743.png

srk0609
8 - Asteroid

Thank you for putting together solution

Labels
Top Solution Authors