Splitting rows into diffent sheets

[saiirangam]

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

[chandler-gjino]

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!

[binuacs]

@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-...