Splitting rows into diffent sheets

Question

Hello Everyone,

I have a scenario where we are retrieving millions of rows from Database   which is having user information. we have 10+ millions rows

I need to split my data into different sheets into excel. there is no other column to group by. If I use record and split into different sheets there are chances names can be duplicated in the input, i don't want split duplicates into different sheet for example Name1 has 10 rows, all the 10 rows should be copied into one sheet. record Id there are chances 5 rows for Name 1 into 1st sheet and rest in 2nd sheet.

Can Someone help me please

binu_acs · Answer

@saiirangam The below post might be helpful for your use case

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/How-can-we-split-the-lakhs-of-data-into-multiple-sheets-with/td-p/1144804

chandler-gjino · Answer

you can try using the 'Tile' tool found in the prep palette.
you can set it to equal records AND also designate it not to split on a certain field
then you can output and create sheets based on the TileNum

if you click on the tile tool and select open example, you should see a few different examples of how it can be configured!