Change path of inputs with different structure that are located in the same Excel

Question

Dear community,

I have the following situation:

We work with 1 input Excel file that includes 6 sheets, all of which address different topics in our workflow and, hence, include completely different columns. We would like to change the path to the input Excel file for all (6) Input Tools in Alteryx at once.

Is this possible? So far, I was not able to find the working solution.

Any help is much appreciated.

Best regards,

Fredrik

IraWatt · Accepted Answer

Hey @futesch,

Have you checked out some of the community tools in the Gallery? @mceleavey's has a Dynamic Multi-File Sheet Names tool which can be used to dynamically get all the sheet names in a workbook like so:

After that you could try the Import Multiple Schema Excel Files tool.

HTH,

Ira