How to break up "Output Data"

[AgnesL]

Hi, is there a way to breakup the output data in Alteryx? I have 40k records to export and I want to export 10k records per excel sheet tab or workbook. 

Thank you for your help.

[DataNath]

Hey @AgnesL, you can use the 'Max Records Per File' configuration in the Output Data tool to do this!

[AgnesL]

it doesn't look like it can do it......below is what i am looking for if i have 40k rows to export..... 

sheet1 = row 1-10,000

sheet2 = row 10,001-20,000

sheet3 = row 20,001-30,000

sheet4 = row 30,001-40,000

[DataNath · Accepted solution]

Ah @AgnesL, you said per sheet or workbook sorry. If you definitely want to do it into separate sheets then I'd:

1) Assign a RecordID

2) Use this RecordID to calculate which sheet each row belongs to - Ceil([RecordID]/10000) - and then format this

3) Output Data, taking the 'Change File/Table Name' field from the SheetName field you just made

Pictures and workflow below:

[AgnesL · Accepted solution]

@DataNath It works. Thank you so much for your help.