Dynamic Data load for app interface elements

[Jain]

I am looking to create an application interface in Alteryx such that the interface elements(drop box, list box) are updated in runtime with values from specific queries against a database. These queries in turn need to take parameters from the users using the application.

Any ideas/suggestions on how to accomplish this.

[apathetichell]

chained apps. you need an outer app to write the files to generate what you're using in the apps with your interface elements.

[danilang]

Hi @Jain 

You can find out more about building chained apps in the interactive video series here. Let us know if you have any follow up questions as your working through this.

Dan

[JagdeeshN · Accepted solution]

Hi @Jain,

You can accomplish this by employing the concept of chained applications in alteryx.

https://community.alteryx.com/t5/Interactive-Lessons/Chaining-Analytic-Apps/ta-p/243120

One way of implementing this is as below:-

1. Create the first application with interface elements to get the inputs/parameters from the users
2. Within the same application, use these parameters to run a dynamic query (Dynamic Input Tool) and extract the data from the database.
3. Write this extracted data into flat files (yxdb), within the workflow development folder.
4. On successful run of the First Application, chain the second application to run next.
5. Within the second application, create interface tools(drop down/listbox) to load the name value pairs from the respective flat files you created earlier.

Hope this helps.

Best,
Jagdeesh