What's the Best Option for Splitting This into Two Files?

[Chad_Cox]

Intermediate excel user here working to convert processes to Alteryx,

I have a workflow started and now I'm at the point where I need to take a file/spreadsheet and break it into two files.  The breakpoint is where there are no more values greater than 0 in columns SSDB, SSB, SDB, or SB.  These are the first 4 columns in the data and they have already been sorted and duplicate values removed left to right.

So, what is the best way to break this so rows 1,403 and up go down one path and rows 1,404 and down go down a different workflow path? I was thinking filter but I'm struggling with the logic that will always find where the break is.

[Matthew · Accepted solution]

your instincts are correct, the filter tool will split it for you.. the logic should look something like this

[Chad_Cox]

Prefect logic , works great!  Thank you!!