Interface drop-down tool not importing data from SQL table

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

Drop-Dwon tool showing column header.PNG

Interface tool connected to DB.PNG

Interface Tools

Accepted answers

JoeS

Sure, I think you'd want the statement to be:

Select
LookUp.[Connected Party] as NAME,
LookUp.[Connected Party] as VALUE
From LookUp

All comments

JoeS

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

DanLarbalestier

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?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703