We’re aware of an issue with email notifications. If you notice you’re not receiving emails from the Community, please check your SPAM folder and release the emails. This should temporarily resolve the problem while we work behind the scenes to solve the larger issue with our mail sender. Thank you for your patience!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

how to dynamically populate a listbox in an analytic app from a file

7 - Meteor


here is my problem :

I want to dynamically populate a listbox userd in an analytic app using values stored in a file.

the problem is that it works only after having run the app

to reproduce : load and save the app and the txt file

run it as as analytic app -> it shows all the rows of the file

modify the file by adding or removing a row

run the app as an analytic app -> it shows the same values as before


so, the question is : how shouls I design the app so that it takes the values of the file ?

22 - Nova
22 - Nova

Hi @olivierMPW 


You would need to build a chain app.


1st app: creates the list of options from the file

2nd app: shows it as options in listbox.


Refer to this post : https://community.alteryx.com/t5/Dev-Space/How-to-Choose-multiple-files-in-analytic-app/m-p/823459#M...


Hope this helps : )

7 - Meteor

here is included a little sample

test_lb.xlsx contains 2 fields, 1 category A, B and fiels contains values

appelant is the calling app

run it as analytic app typing A then B and see what happens