Alteryx Designer Desktop Discussions

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

Sample work for Drop Down Interface with external source

uğur
6 - Meteoroid

Hi, Can you share the sample work for drop down interface with external source.

I can not find any sample or video this issue.

 

Thanks, best regards

Uğur

4 REPLIES 4
fmvizcaino
17 - Castor
17 - Castor

Hi @uğur ,

 

Attached is an example using the file browse tool, is that it?

fmvizcaino_0-1591191681912.png

fmvizcaino_1-1591191705980.png

 

Best,

Fernando Vizcaino

 

 

 

 

rupali_bhise
8 - Asteroid

Hey @uğur , 

 

Attaching sample workflow and sample data for your reference , how to use drop down with external source data. 

In the Drop down tool, you need to define 2 columns into file  1st one is Name and 2nd one is Value, and Drop Down tool consider values column for Drop down options.

Take a look, it will solved your issue.

 

Good luck

uğur
6 - Meteoroid

Thanks Fernando for your fast feedback. 

But , my request related database connecting and populate lookup data in the drop down interface.

fmvizcaino
17 - Castor
17 - Castor

Hi @uğur ,

 

Solution attached. One thing to be aware is that you need to run your workflow once for the drop-down values appear as it should, so if it happens to have new values for your drop-down in your dataset, this solution will not work.

 

Best,

Fernando Vizcaino

Labels