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

Alteryx Designer Desktop Discussions

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

Batch macro repeating information from first tab multiple times

chcreamer
5 - Atom

I have a batch macro that should loop through all tabs on the spreadsheet, running the process on each tab.  Instead, it's returning the data from the first tab multiple times, once for each tab on the input file. Any ideas?  Thanks in advance!

chcreamer_0-1674575825046.pngchcreamer_1-1674575879264.png

 

3 REPLIES 3
FinnCharlton
13 - Pulsar

Hi @chcreamer ,

Are you selecting a field to group by in the batch macro configuration? Group it by a unique field, like a RecordID.

SPetrie
13 - Pulsar

Possible that your action tool isnt updating the file input so its just running the "entry forms" tab you used as the template.

Is your control parameter passing the full path with sheetname?

chcreamer
5 - Atom

Thanks so much for your response.  Sorry I'm so late getting back to you.  The issue was actually a bug fix after upgrading to a newer version.

Labels
Top Solution Authors