Alteryx Designer Desktop Discussions

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

Batch Macro Help

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. 



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


Hope this helps 🙂