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
Solved! Go to Solution.
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
Hi @futesch there are number of ways you could tackle this. The first is going to Options - Advanced Options - Workflow Dependencies and changing the file in all the Inputs at the same time. However that requries a user make the changes before running. A more dynamic solution would be to use either the Dynamic Input or Batch Macro solutions proposed in this article given you have different sheets with different columns you may need to use more than one Dynamic Input of Batch Macro but could feed them the file name from a single directory tool.