Dynamical update list box values thru YXDB in alteryx gallery

[Labhesh]

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 ?

[Bobbyt23]

It could be a couple of things, when you uploaded the app did you send the yxdb for the list box as an attached asset?

If you did it only takes the values as they are and won't update.

If you untick the box for it and don't send it as an asset the workflow will then grab the file from where it is saved instead, the one that is being updated.

Things to know, your server will need access to where that file is being saved, if it doesn't it may be worth making that process part of the app itself.

[Labhesh]

Thank you for your prompt response @Bobbyt23 

It could be a couple of things, when you uploaded the app did you send the yxdb for the list box as an attached asset?

Ans: yes i have checked all the assets in the setting and taking in the gallery..

So that means if i dont check the assest and give the path to local drive  in list box etc that path have an access to gallery, it will pick the updated file daily that we are updating regularly ?

AM I RIGHT?

[Bobbyt23]

Yes that’s correct.

i always try and think of it that anything ticked goes up to Gallery as is, anything unticked will be fetched by the workflow when run.

as long as gallery has access to the location you are saving that file it will update.

[Labhesh]

@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.

[Bobbyt23]

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

[caltang]

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.