I am creating a workflow in which the user selects a file with multiple sheets, and I would like Alteryx to be able to import all sheets from the file with a single file browse. I was able to accomplish this using the process below:
The user selects a file but does not choose a table/sheet name, and clicks OK.
The multiple action tools then replace the specific strings which are just the filename.xlsx| without the sheet name.
The input data tool then provides the appropriate sheet name.
However, when I run this app in the Gallery, I am required to select either <List of Sheet Names> or one of the worksheets.
Is there any possible way to not select of these options while working in the Gallery as I am able to do locally? I do not want to have to add a file browse for each individual worksheet, as that would make this app much less user friendly. Thanks!
