Alteryx Batch Macro Loop

Hi There.....

can you help.....i have data where i can only extract a certain number of rows per workflow run...

Therefore i need to run the same workflow multiple times and union each run/loop together to get all data...see below....

output required.png

Ideally i want a macro to be able to feed in the input and number of loops count and then produce the output...

I want to go from Before to After......and need help to create a batch marco to loop the input the number of times i want

Before workflow attached.....I need the After Workflow as answer........

macro loop before after.png

Macro Loop.yxzp

region sales loop.xlsx

output required.png

macro loop before after.png

Batch Macro

Data Investigation

Accepted answers

Mathias_Nielsen

I see, the batch macro will automtically union the data together before output. Just make sure that each of the "loops" have a unique identifier, as the control parameter of a batch macro will be used to group the data by. So each of your queries will have to be tied to that control parameter/loop. So basically like you have shown there in the blue where they are in their own record. I would personally split it like this:

loop1 | 1 | 1000

loop2 | 1001 | 2000

So that there are three columns that should make it easier to replace the ranges in your quuery. Choose the "loop" column as the control parameter and you should be a long ways with your macro

All comments

OTrieger

@DelData

What is your question?

DelData

How do i create a batch marco to loop the input the number of times i want?

Mathias_Nielsen

Hi @DelData,

Have you tried generate rows?

Just change the number at the red arrow.

Hope this helped

2024-11-11_14-45-58.png

2024-11-11_14-46-12.png

OTrieger

@DelData
Watch the Macros interactive lesson, it will give you a good idea on what to do.

DelData

no.....what i am after is help for someone to show me how to create a batch macro to push the same input file in a set number of times....this is what will help me

DelData

no.....what i am after is help for someone to show me how to create a macro to push the same input file in a set number of times....this is what will help me

Mathias_Nielsen

Can you explain why you need the same file multiple times? You said you can only extract a certain number of rows.

I know in an excel file you can take only a certain range, you could modify the range for each run if that's what you want.

2024-11-11_15-00-05.png

DelData

if the server says i can get 1000 rows of data and the total rows is 4000

then i need to run my workflow 3 times...I will send request to server and all i will update the row numbers i need to grab...show in bue below

loop1 = rows 1-1000

loop2 = rows 2000-3000

loop3 = rows 3000-4000

Mathias_Nielsen

loop1 | 1 | 1000

loop2 | 1001 | 2000

So that there are three columns that should make it easier to replace the ranges in your quuery. Choose the "loop" column as the control parameter and you should be a long ways with your macro

DelData

Thanks Mathias.....this conversion helped me and you have now answered what i need to do....sometimes a chat for ideas fixes the issue 👍

Mathias_Nielsen

Glad to hear i could be helpful, good luck with your macro

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703