Spliting values into multiple excels

Question

Can someone help me with how to take a table with 1,000,000 records and split the data so that the first 10,000 records go into an Excel file named "1.xlsx," the next 10,000 into a file named "2.xlsx," and so on, while making sure that the header from the original table is included in each file? I'm new to Alteryx and would appreciate any guidance on how to perform this action.

Raj · Answer

@Hursan 
find workflow attached for reference
hope this helps

3298.yxmd

KGT · Answer

Create a field with the sheet name. RecordID followed by a formula to edit that ID. RecordID = CEIL([RecordID]/10000)

Then in the Output tool, there is a section at the bottom of the configuration window to "Take File/Table Name from field".