Spliting values into multiple excels

[Hursan]

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.

[KGT]

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

[Raj]

@Hursan 
find workflow attached for reference
hope this helps