Alteryx Designer

Find answers, ask questions, and share expertise about Alteryx Designer.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.
SOLVED

Update a Drop Down List from a SQL Query

Highlighted
6 - Meteoroid

Hi guys,
I am using a Drop Down tool in my app. I would like to dynamically update the option list as the output of a SQL Query. For example, if my query produces a list of customer, I want the app allows to choose among all customers in that list.

How can I do it?

 

Thank you,

Giorgio

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Youtube post:  https://www.youtube.com/watch?v=0Wm8vIwnD6c

 

Youtube video:  

 

This post shows how to chain/link applications so that the first app reads the database and prepares the listbox to include relevant options in the second application.

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Highlighted
6 - Meteoroid

Thanks,

Actually we found the solution by selecting External Source in the drop down menu

Cattura.PNG

 

 

And then typing the SQL query in "Properties" field

Labels