Alteryx App UI Dropdown question.

[ChrisSpr]

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 solution]

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.

[ChrisSpr]

Bee's Knees! Works perfectly, Thank you!