Need to populate Interface Dropdown Tool in Analytic App with data from a database

[avanibhatnagar]

I have this Analytic App I'm trying to build where I need the Dropdown to populate with a list of Company names from a table in my database. When I run this app though, the dropdown does not populate with the data that I'm passing to it through the database. Is there any way to do this? I would think this would be possible and seems like it is using these tools, but I'm clearly missing something. 

[alexnajm · Accepted solution]

It's only going to show "field names" when connecting in like that, so you may want to Crosstab right after your Select!

[avanibhatnagar]

That did it. Thank you!!!
Weird that it replaces spaces with underscores, and I have to have an additional field that I don't need and that will end up being one of the options in the dropdown (since I need a group by). I wonder why it only allows field names. Either way - that did it so thank you for the help @alexnajm  :)   

[alexnajm]

The Crosstab tool does that annoyingly - you could use the Dynamic Rename to formulaically replace those underscores with spaces!