Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Cloud Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Cloud.
SOLVED

Macro Help - from one file to multiple files and multiple tabs

ABHalpain
7 - Meteor

Good afternoon Maveryx Community,

 

I have what appears to be a very simple issue that is just not giving me the output I am expecting.  I have attached the Macros and source file.  The work flow and macro are close I just cannot figure out what little step I am missing to get it across the finish line. The target would be to have the following files with the respective tabs:

 

ABHalpain_0-1687474029933.png

 

 

 

Thank you for any help that you can provide.

 

Andrew

 

(Sorry for the duplicate post the first one I put in the wrong place) 

2 REPLIES 2
ArnaldoSandoval
12 - Quasar

Hi @ABHalpain 

 

You certainly were close, these are the changes I made to get the output you are expecting!

 

Macro's changes:

  • Added a filter on the [RollUp] field.
  • Changed the configuration of the Output Data tool to "Overwrite Sheet or Range"
  • Your macro input file: Input Data.xlsx was not shared, I had to create one on the fly..

Solution-01.png

Solution-02.png

Application's changes:

  • Remapped the Macro's question to select the field: [RollUp]

Solution-03.png

 

Notes:

  • I renamed the application to MultipleFiles v2
  • Added all the files involved in the solution package.
  • Tested the Solution Package locally.

Hope this helps,

Arnaldo

ABHalpain
7 - Meteor

@ArnaldoSandoval Thank you so much for your help!! This is great!