List tool

[udayan]

I have 4 datasets in my desktop & I want to select any one of them using list box. I am not able to do that in alteryx. I will be highly obliged if someone give me any solution.

[taylor_butler]

Hi @udayan , 

I've attached an example of how you could do this with the List Box tool - however, the caveat of this approach is that all the datasets must have the same schema. If the schemas vary from file to file, then you would want to add in a macro to open the files, rather than using the Dynamic Input tool. 

Hope this helps!

Taylor

[udayan]

Hi @taylor_butler 

I copied your workflow but faced one issue in it. The error is if I select File2 as a option, the output of the workflow is File1.xlsx|||sheet1. I will attach the screen of my output & the workflow. I will be highly obliged if you give me a solution. My Alteryx version is 2020.2.3.27789

[taylor_butler]

Hi @udayan, 

You need to ensure the Action tool is configured to update the Text Input (shown in the image below), otherwise the app will not correctly update with the users input and will instead run with the placeholder data.

[udayan]

The issue is solved @taylor_butler. Thanks for the guidance.