batch macro

[prravich]

i have a simple excel file with two column( product, sales) as shown below

product	sales
A	5
B	10

I need a batch macro that accepts one product at a time, multiplies its sales by 2 and when i connect this macro to the workflow, i need final output as shown

product	macro output
A	10
B	20

I need batch macro and not a standard macro because the real data is complex and uses a R code which can only take one product at a time. I am not sure how to configure the control parameter so that macro accepts one product at a time, doubles sales and moves to the next product and so on.

[T_Willins · Accepted solution]

Hi @prravich,

Attached is a simple batch macro that processes each product individually.

Workflow

Macro

[echuong1]

The key with a batch macro to control the number of records being brought in at a time is the group by tab in the configuration window. You can specify to group by the Product value, so records are brought in product by product.

See this article for more information about batch macros:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Getting-Started-with-Batch-Macros/t...