Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

Chad_Cox
7 - Meteor

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.

2 REPLIES 2
Matthew
11 - Bolide

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

 

Matthew_0-1663941036592.png

 

Chad_Cox
7 - Meteor

Prefect logic , works great!  Thank you!!

Labels