Hi
I am trying to configure an Interface Drop-down tool with a list from a SQL table. I have connected to the database, table and defined the column in the SQL statement, however the drop-down tool only shows the column header.
Do i need to further configure the drop-down tool in any way?
Thanks in advance,
Dan
Solved! Go to Solution.
Hi Dan,
With the workflow that you have created the In-DB tools will need to run in order to produce the data that you want to display in the dropdown.
You are seeing the metadata in the dropdown as that is all Alteryx can display at design time.
In the dropdown, there is an option to connect to an external source, this is what you need to use if you want to display the values from a table/select statement.
Please note the columns need to be "NAME" and "VALUE"
That should then give you the options you require
Thanks Joe
This may seem like a silly question but the NAME & VALUE piece confuses me a little. The data type is a string and has no value associated with it.
Am I going about this in the wrong way?
That's not a silly question at all.
The name is what the user will see in the dropdown, the value is what will be put in the data.
Often these are the same thing, but sometimes the user may want to see and choose from a description, but the data needs to have the code.
In your select statement you can just have name and value set to be the same thing, if need be.
For Example:
NAME|VALUE England|ENG Wales|WAL Scotland|SCO Ireland|IRE
Sure, I think you'd want the statement to be:
Select LookUp.[Connected Party] as NAME, LookUp.[Connected Party] as VALUE From LookUp
Cheers Joe
Much appreciated!
No problem, glad you managed to get what you wanted!