Changing Detours with Formulas

[Peace_B1]

Hi all, 

I am writing a macro that will be an input tool for various sources of data we use (Fare Sales, Fare Earned, Fees Sold, Fees Earned,  Vouchers Issued, Vouchers Used, etc.) I work in the Airline space.

In order to read in data that has differing schema - i have multiple dynamic inputs. I am trying to write a formula action tool for the macro to route the data to the proper dynamic input based on a drop down. 

Below are my drop down options

My error is at the detours - this detour should route the data if it is presented with the "PNRURExtract" as its #1 

However - it routing everything to the L output no matter what is selected in the dropdown tool.  This is the format of the Action tool.

Anyone have any ideas on what i can try?

Thanks, 

[ChrisTX]

Try the formula IF !Contains([#1],'PNRUR') THEN 1 ELSE 0 ENDIF

You might need to swap the 1 and 0.  0 is False, 1 is True.

Chris

[Peace_B1]

Same result - i actually tried that with "true" and "false" instead of 1  and 0, but that was a good suggestion. Just so weird ive looked through everything possible it seems.

[ChrisTX]

Look at the Data Cleansing tool.  There are some Detour examples in that macro.

[SPetrie]

It looks fine to me and when I setup something similar it works.

Double check the action tools formula variables and make sure that #1 is actually the drop down.

Are the detours feeding back into an end detour as well?

I cant think of anything other than that that could cause issue.

As an alternative, another route would be to use containers that are turned on/off using the action tools as a method of controlling the flow and what dynamic inputs are active.