Dynamical update list box values thru YXDB in alteryx gallery

Question

Hi Community

I have one quesry realted to alteryx gallery worklows here as follow:

I have Uploded the analytical workflow to alteryx gallery that have list box with yxdb as a source in it which is connected to action tool then filter for which updates as per values selected buy user in alteryx gallery list box interface..

So now my question

As i told above values in list box are coming from yxdb inside list box as a source to create these yxdb there is schudeled workflow that excute every day and update to those yxdb in our local system from where we have ben uploaed the workilow to gallery..but somehow the workflow that has been uploded is not able to updated those yxdb's as my wokflow has multilple filters and with list box, drop down etc

So how we can update those list box values dynamically ?

List Box alteryx gallery.png

caltang · Answer

Chaining is definitely one way to go and I agree with @Bobbyt23

If you want an alternate solution, you could make an Excel file with only headers with your Month-Year combination for all possible combinations.Then you can make the analytic app something like this:

The file browse tool will enable you to drop that excel file you just made into the app, and the list box will automatically update all fields as selection variables that resolves your need without running twice.

Alternatively, you can consider a different approach rather than a list box. You could make a query builder via a formula tool... but this will require your end users to write it in a specific format.

For example, they can write out "Jan-2025","Feb-2025" etc, but it is tedious.

Those are alternate ways you can consider. Hope it helps.

Bobbyt23 · Answer

Ah in that case you will need to look in to chained apps.

check these out: https://www.thedataschool.co.uk/brian-scally/chaining-apps-in-alteryx/

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

Labhesh · Answer

@Bobbyt23

The issue is that, as you mentioned, the filter values will only show when the workflow is run. However, users need to be able to select the values from the list before running the workflow to get their desired output. The folder will have access since the main input file is also being fetched from there, which we are sure of.