topic DropList Tool using External Source (NAME && VALUE) working in desktop but not in server in Alteryx Server Discussions

DropList Tool using External Source (NAME && VALUE) working in desktop but not in server

DrydenChicago — Wed, 18 Aug 2021 22:14:05 GMT

Hi all,

I have this Interface's DropList tool using the "External Source (NAME && VALUE)" which connects to data mart to get the most recent updated list of selections. It's important to use the list of selections rather than user input which can results in human common errors. The first picture I have below is working good from my desktop but the next picture shows that it's not working at all in the server which is showing blank information. I've searched the community and found this post below.

https://community.alteryx.com/t5/Alteryx-Server-Discussions/Dropdown-list-from-SQL-Table-in-Analytic-App-on-Gallery/td-p/502340/page/2

This sounds like crew macro was the solution but that was an old post. I would like to check if there's a new solution beside the use of crew macro.

Re: DropList Tool using External Source (NAME && VALUE) working in desktop but not

BrandonB — Fri, 20 Aug 2021 04:55:43 GMT

The easiest way is to leverage a chained app as explained by DanM here: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Interface-DropDown-does-not-populate-on-the-server-with-updated/m-p/480442/highlight/true#M96717

Your first workflow queries the table and writes the name/value table to a yxdb file. Then your second workflow uses this name/value yxdb file as the external source to read in the values.

Re: DropList Tool using External Source (NAME && VALUE) working in desktop but not

atcodedog05 — Fri, 20 Aug 2021 14:33:37 GMT

Re: DropList Tool using External Source (NAME && VALUE) working in desktop but not

DrydenChicago — Fri, 20 Aug 2021 14:29:17 GMT

Thanks BrandonB. I was hoping to avoid the extra step of writing to a yxdb file. It'll need to be dynamic and based on what's available in the data mart.