Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

futesch
5 - Atom

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

2 REPLIES 2
IraWatt
17 - Castor
17 - Castor

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:

IraWatt_0-1651568997716.png

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

HTH,

Ira

 

JosephSerpis
17 - Castor
17 - Castor

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. 

Labels