In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Alteryx App UI Dropdown question.

ChrisSpr
8 - Asteroid

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!

2 REPLIES 2
echuong1
Alteryx Alumni (Retired)

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.

 

echuong1_0-1615498976233.png

 

ChrisSpr
8 - Asteroid

Bee's Knees! Works perfectly, Thank you!

Labels
Top Solution Authors