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.

[CosimaS]

I have a pretty extensive workflow that produces millions of rows--what I put in the post was just a super boiled down version of the basic macro concept I can't get. The workflow has a text input with one row of data, and I want to build a macro where I feed in several rows and then it takes each row and runs it through