I have a large text file that has many page breaks that are denoted by a line "___________________". I need to create separate text files for each section (create a separate file at each page break). I am new to using Alteryx and not sure how I can do this. Thanks in advance!
Solved! Go to Solution.
Possible to share sample data ?
Here you go.
The mulit-row formula creates a new filed called FileSuffix that get incremented every time it finds a "_______". The output tool is configured to add the suffix to the output file name and so creates a new file every time the suffix changes
It currently includes the "__________" row in the output files. If you want to remove them add a filter after the multi-row tool and set the custom filter to
!Startswith( [Field_1],"________") |
Dan
Thank you!