Dropdown tool not updated after updating the input file

HI,

I am developing small app where I used the dropdown tool. This dropdown tool is connected to input file from where the dropdown value is reflected while running the workflow as APP.

The problem is while I updated my input file then updated value is not populated in dropdown list.

I save the Excel file in particular location and this file used in app.

Is there any way where I can update the dropdown tool value while opening it as APP whenever I update the excel file

Thank you in advance.

Workflow

Developer

Gallery

Developer Tools

Input

Custom Tools

Best Practices

API

Apps

Batch Macro

Interface Tools

Chained App

Iterative Macro

Behavior Analysis

Alias Manager

Accepted answers

All comments

afv2688

Hello @alt_tush,

If you fill your dropdown list with a connected tool you won't have the updated information. if you run the workflow and then check afterwards you will see that it is in this case updated. That is because before running the application, the dropdown will always have the options listed from the last run.

I would recommend to have the tool connected to an outside source (a file with all the options)

Regards

alt_tush

Hi afv2688,

Thank you for your quick response. Do you have any example which you can share with me.

Also I want to deploy this app on Alteryx gallery. So whenever my Excel file updated or add any value then it should automatically updated or refresh in Dropdown.

Or else if it is not possible in dropdown, can you please help me on any other alternative.

Really appreciate your help

Thanks 🙂

apathetichell

so I was running a drop down from a macro and came up with an interesting hypothesis:

In your base macro if you set up your initial data as coming from a text input versus a file input your dropdown choices WILL update at run. If you use a file your choices are fixed based upon the initial file which the dropdown was connected to...

I've been working on a macro which provides what continuity with respect to the percentage of dependent variable in test/train data sets. (in R this would be the Sample.Split function. I was having an issue with getting a macro which would take new data in and allow for field selection based upon that new data source, and a further issue with the dropdown not updating...

I decided to see how Alteryx handles this issue with predictive tools with embedded dropdowns (ie most regression model tools)... I noticed that Alteryx relies upon text input for all dropdowns which will be overwritten by user data in predictive macros.

Alteryx itself uses text inputs to get their dropdowns to work. I reset my macro to use a text input vs a file input and voila. It works.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703