Alteryx App UI Dropdown question.

Question

So quick Q maybe you all can answer:

How can i use the interface Drop Down with two option (EFC, and TFC) replace a part of a sql query with either 128 (EFC) or 138 (TFC).

Does that make sense? I want the drop downs to read different than what they replace in the sql

I've done date replacements but that's 1:1 on data.  This is "if Dropdown = TFC then 138" kinda deal.

Danke!

echuong1 · Accepted Answer

You'd list both in the drop down, separated by a colon. The first piece is what the user sees, the second is what is actually passed through the app.