Using batch macro with summarize function

[MarkEugene9000]

Hello,

We are sending API calls to a program that only accepts 100 records at a time. To that end, I'm trying to use Alteryx to separate my data into groups per 100 records, and then use a batch macro to send each batch of 100 records onward in a summarized format. I am having a disconnect understanding how to pass through the grouping value as the control parameter between the main workflow and the macro itself. 

In the attached materials I am simply trying to demonstrate getting output three files based on the original data: one for the first 100 records, one for the second 100 records, and one for the rest. 

I'm sure I'm missing something basic - any tips would be very appreciated.

Mark

[gc · Accepted solution]

See attached. Does that help/work for you?

[MarkEugene9000]

Hello,



Thank you. This is very close to what I needed. My final goal was to get
three separate files, but I was able to tinker with your solution to get
there.



Mark



--



Mark Gauzens

Senior Analyst – Westgroup Research

602.707.0087 or 602.707.0050 ext. 231