workflow path based on condition

[adampolcz]

hi Experts,

In my workflow I need a tool that based on a condition it will go PATH-A if this true, or use PATH-B when false. Basically in my list if it contains not just P1 (period1) figures in needs a logic after, but if the list contains only P1 that logic after needs to be sidestepped.

Be aware please that this is not a filter tool or split for P1 data and not P1 data because I need to handle the whole data as one. Nor a formula tool. I tried condition tool but that surprisingly does not connect, so I am stuck.

This matter is so simple. I need a path-junction based on my data. Imagine a steam train goes from A to B on steam route, an electric goes on wired route. Why is it so difficult?

[alexnajm · Accepted solution]

You can calculate a new column (not sure I understand your logic fully for this) using a Formula or a Summarize perhaps to basically create a label on if the dataset should go to Path A or Path B, Append Fields the new column/record to the entire dataset, and THEN use a Filter on that column to pass it to one path or the other. 

[adampolcz]

Thanks a lot for this. However alteryx should behave not like this. It is intricate.

[alexnajm]

I'm sure you could build a macro to do this, but because there's no tool that I am aware of that splits on both logic of rows and columns, this is the way it is!