Setting up a batch macro

CosimaS

Incredibly simple question. I am trying to set up a macro that just loops through the rows of a text input and I cannot figure it out. So it would be like this:

Input:

iteration	col1	col2
1	A	B
2	C	D

Macro input:

iteration	col1	col2
input	input	input

(one row at a time)

Macro output:

iteration	result
1	result for iteration 1
1	result for iteration 1
2	result for iteration 2
2	result for iteration 2

(so the union of the results for each iteration)

Does anyone have an example of how this is done?

Emmanuel_G

Hi @CosimaS ,

I don't know if I understood your request correctly. But to get to the result you are outputting, you don't necessarily need a macro.

With a transpose tool and a quick reprocessing of the strings, we achieve the expected result as shown in the screenshot below and the alteryx stream attached.

Workflow.yxmd