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.
Solved! Go to Solution.
Hey @AgnesL, you can use the 'Max Records Per File' configuration in the Output Data tool to do this!
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
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:
@DataNath It works. Thank you so much for your help.