In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start 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