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

[vargasw]

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

[KGT]

This is an issue with your configuration of a tool. We can't troubleshoot something we can't see.

I'm guessing by "Browse File", you are referring to the "File Browse" Interface Tool. Is this an App or a Macro? The Interface tools will not do anything otherwise.

The Dynamic Input tool can be a little finicky, but it sounds like you are not replacing enough in the options.

[abacon]

@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

[vargasw]

@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.

[vargasw]

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