Alteryx Designer Desktop Discussions

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

Batch Macro Help

MFish
8 - Asteroid

Hey all,

 

I have a workflow where I pull in multiple xlsx with multiple sheets and schemas through a batch macro, and union the results once they're standardized. 

 

I then want to 'validate' this data with various tools in a workflow, but i want to do it for each set of data that has come in - so basically feeding it back into a batch macro and then joining it back after again. Sort of moving the data through stages.

 

I'm not sure how to pass it back into a batch macro in a way that splits it - I have added a field with the fullpath to keep it grouped, or am also able to add record IDs/Groups for each sheet. 

 

Any thoughts - hopefully this makes sense. 

 

Cheers

1 REPLY 1
atcodedog05
22 - Nova
22 - Nova

Hi @MFish 

 

Why not give iterative macro a try it's more flexible.

If you want to repass the data again till it meets the condition

 

https://community.alteryx.com/t5/Videos/Build-Your-First-Iterative-Macro/td-p/55565

 

Hope this helps 🙂

Labels