This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Right now, I have to do a little voodoo to get a user to select a sheet within an excel doc to use as a source. My use case is that I have an excel file provided by other users in which the relevant data could be in one of many excel sheets, and there isn't a good programmatic way to determine the right sheet. Thus, I want to prompt my user to select the sheet when running an analytic app.
I have to start with a file browse option to prompt the user for the excel:
From here, the prompt will only ask for a file:
At no point will it prompt for the sheet it wants within the file. And the action options don't give you the ability to change the sheet (it reads it from the file input after the pipe):
To solve this, I have to create a app that only prompts for the excel sheet and then set it to output the sheet names. From there, I do a little formula magic to split it into key-value pairs with the value being the entire file path pipe concatenated with the sheet name, save it to a file, then read the file in a second workflow which presents the sheet names in drop downs. It looks something like this:
This all seems unnecessarily complex given Alteryx seems to have already figured this out in designer:
My idea: Use the same file selector in the "Input Data" tool for the File Browser when setting the File value from an Action. It would save me from having a separate workflow just to prompt a user for an excel sheet.