This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a workflow that uses a List Box that is populated via select query from Database. When I run the workflow as Analytic App in Alteryx Designer Studio, I am able to see all the values however when I upload the workflow in Alteryx Gallery, it doesnt display any value and is just empty.
The list is not populated because Alteryx needs to actually run to query the DB and get the up-to-date list of values. If you just load the app this doesn't happen. In order to populate the list box dynamically using a query on a Database, you will need to use something that we call chained apps - find out more about these here.
The first app will be used to get the list of values which will be saved into a file - eg values.yxdb. On success of the first process the second (chained app) will be triggered
The second app will use the values.yxdb just created to populate the list box.