Alteryx: How to branch to one path or another depending on what type of ID I have?

Category:
Question ID: 109833
0
0

I want to format a name one way if my ID ends in A and another way if my ID ends in B in this workflow I’m dealing with. I’ve found the detour tool and set up a workflow for both options, ending in a detour end, but I can’t figure out how to flip the detour depending on what kind of data is coming through. Any help would be greatly appreciated.

Marked as spam
Posted by (Questions: 7, Answers: 0)
Asked on September 10, 2020 5:56 pm
3 views
Answers (1)
0
Private answer

The Detour tool is really more meant to be used with an application that has an interface and is meant to accept user input. There isn't a clean way to change the direction of a detour based on your data stream... But the good news is you don't need to! It sounds like your problem could be solved with a simple IF THEN ELSE formula tool. And if that doesn't work you could also use a Filter to determine if the end of the ID is A, and do different things to the true and false datastreams. Then combine them back together using an Append tool.

Marked as spam
Posted by (Questions: 0, Answers: 6)
Answered on September 10, 2020 6:21 pm