Input Cross Tab to use as List Box Issue

[kalvinharris]

So I've setup a fairly simple workflow to pull in a field to use as a list box to update a filter in an Alteryx app. See below:

The issue I'm coming across is when I initially open the workflow, any changes in the input Excel file would not be prepopulated in the interface tool and you'd have to run the workflow first to update the interface list box. As I'm trying to streamline the workflow and make it as simple to run as possible with just using interface tools, is there any workaround?

[gabrielvilella · Accepted solution]

Hi @kalvinharris, you will need to create a chained application. The first app will list the possible values given the most recent file, then it will write an output file so then next app will read it and populate the list box. This video explains it: https://www.youtube.com/watch?v=0Wm8vIwnD6c&ab_channel=MarkFrisch 

[kalvinharris]

Perfect! Thank you very much for the response

[grazitti_sapna]

@kalvinharris, an example of a chained app specific to your problem statement. 

I hope this helps!

Thanks!