Drop Down tool isn't getting the latest data - Analytic App

Dear all,

I created an Analytic App workflow where I'm using the the Drop Down tool configured to get "Fields from Connected Tool".

So, every time I Run as Analytic App my Input File is updated and the data that goes to Drop Down tool change. It's possible to confirm that my data is being updated looking to the input file (Excel). Until here... OK!

The issue is that de values (based on Fields) in my drop down aren't being updated:

Running as Analytic App

The first time I've the following values in the Drop Drown:

After I run it for the first time (selecting 'A12'), my data will be updated and it won't have 'A12' anymore.

Running for the second time, it should have the values updated and it only shows from A13 onwards... For example:

But what happens is that I keep having the same list with 'A12', even with my input (Excel) file updated.

The way that I found to update the values is, open my Analytic App file in Alteryx (instead of running it); run normally; run as Analytic App through Alteryx; and save the file again... After this, I can see the values updated when I run the Analytic App directly.

Is there any way that the drop down get the latest values automatically?

Am I missing some setting or something?

Thanks!

Workflow

Accepted answers

caltang

If you are running a Chain App, then your first workflow should get you all your Names & Values, so that your current workflow (2nd one) will call from that output in your interface tool (drop-down tool in your case).

Running the first chain app will always generate you the updated list required.

Another method is for you to attach a file browse to your drop-down tool (both are interfaces), then your file browse should showcase the output values accordingly.

If you ask me, I prefer the first method with Chain Apps because I know it will always work for me.

FabioP

Hi @caltang

I was working on this issue here (trial/error) and I ended up getting it to work similar to the second way you mention. After I understood that the Drop Down tool had its values loaded before read the input file (in de way I was doing before, using option of "Fields from Connected Tool"), I changed to load values from "External Source" and these files are updated along the same workflow.

Anyway, thanks a lot for your help!

All comments

caltang

Running the first chain app will always generate you the updated list required.

Another method is for you to attach a file browse to your drop-down tool (both are interfaces), then your file browse should showcase the output values accordingly.

If you ask me, I prefer the first method with Chain Apps because I know it will always work for me.

FabioP

Hi @caltang

Anyway, thanks a lot for your help!

soniayadav

U am facing the same issue ,my drop-down tool doesn’t get refreshed automatically instead it picks up the hard coded value when u run it as analytic app but when I run it manually it is working fine

KGT

You'll need to post a pic of the workflow, but I'm pretty sure I know what it would look like and where the problem likely is. Apologies if this is not it.

The interface tools get configured before any of the "standard" tools run. So, if you have an input, then a select, going into the drop-down, that will update when you run manually, as the metadata is updated, but when run as an analytic app, it will be the metadata last time it saved. There is no way to make that dynamic without using either an HTML interface, or saving the file somewhere and then using that file to configure the tool.

soniayadav

My 2nd app is taking input from the output if 1st app

KGT

OK, if it's a chained app, then is that dropdown connected to the Macro input Q or connector? It will use the sample in the Macro Input one way, and the metadata coming in on the other connector.

https://community.alteryx.com/t5/Tool-Mastery/Tool-Mastery-Macro-Input/ta-p/112941

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703