This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Here's a neat little trick many forget about. In the output tool, option 1 in the configuration pane:
I've set my value as 2, therefore Alteryx will output separate files, splitting my output into a maximum of two rows per output.
Let's say I have an input of 5 records:
The output with a maximum records per file of 2 (as the above example) would lead to three output files being created, with 2 records, 2 records and 1 record respectively:
This method will be fully dynamic also if the number of records to output changes. If your records increased to 25 you'd output 13 files, 12 of which would contain 2 records and 1 would contain 1 record.
Hope this helps! I've attached my workflow for you to download if needed.