2022.1.1.30569 Patch Release Update

The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs. If you installed the 2022.1.1.30569 release, we recommend that you reinstall the patch.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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
15 - Aurora

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
16 - Nebula
16 - Nebula

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