Browse File - with multiple tabs to be used as separate input

Question

Hi,

Is there a way to bring in an input file that has multiple tabs. Each tab will be used as a separate input. Also, I need to use the Browse File, to allow the user to select their file from any where, with possible file name variation (the format of the file/tabs will not change).

I tried using the Browse File with Dynamic Input to bring in each <List of Sheet Names>, but every time I run the process with a file that has a different file name then the one it was set up with, the workflow does not update the data. In fact, it just bring in the data from the previous run that had the File name that was used during the set up.

Thanks

vargasw · Answer

Thank you for your response.

Yes, I was referring to a File Browse tool, and I'm I was running this with the App.

I will see if I export a simple version of my workflow to demonstrate what I have.

Thanks

vargasw · Answer

@abacon

Hi Bacon,

Thank you for providing the workflow example.

I'm sorry for what might sound like basic questions, but I'm still trying to learn my way around Alteryx as a tool.

With you example workflow:

Will both tabs be brought into my workflow as two separate data input. Are both tab I'm going to be able to chose any file,

Will the user be able to choose any file, with the same format as the one used for set up, no matter where it is saved or the file name?

Thank you very much and I appreciate the time  you've taken to help me out.

Have a good day.

abacon · Answer

@vargasw Here is an app that does it. You don't need to use a dynamic input tool, you just need a regular input tool with a macro.

Bacon

SingleFileDynamicInput.yxzp