Changing Detours with Formulas

Question

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,

SPetrie · Answer

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.

ChrisTX · Answer

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

Peace_B1 · Answer

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.