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

[srk0609]

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.

[Luke_C]

Hi @srk0609 

Maybe one of these can help get you started? 

https://knowledge.alteryx.com/index/s/article/How-To-Split-Output-Into-Multiple-Files-with-Specific-...

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Split-excel-based-on-number-of...

[srk0609]

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 · Accepted solution]

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

[srk0609]

Thank you for putting together solution