Split dataset based on the record value

[Jia_Li]

Hi Team, is there a way for us to divide a txt file at a specific record (row) based on the value within using Alteryx? For example, I have a text file that shows the usernames followed by the actual GL data. I would like to divide the data after the line 3289 labelled "Data file":

[cmcclellan]

I would create a Formula tool that can be as simple as this :

Name : Flag

Calculation : if [field] = "Data file" then 1 else 0 endif

After that, add a multi-row formula to check the previous and current [Flag] values (basically to copy the value to the next record)

When you do this, [Flag] will be 0 until you get to "Data file" and then 1 onwards, you can then filter on the [Flag] value.