Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Looping in alteryx

terrellchong
8 - Asteroid

Hi all,

I creating a loop which is trying to do as follows

 

1.png

 however, when im trying to create a loop, it seems like i was not able to recreate what the output was in the screenshot above.

 

Can someone please inform me what did i do wrong?

5 REPLIES 5
gawa
16 - Nebula
16 - Nebula

@terrellchong 

You don't need to put Filter tool right after Macro input tool because this is Batch macro. If you select Tile_Num as Control Parameter of Batch macro, then the record having the same Tile_Num is fed to Batch macro one by one.

For reference, I attach my WF to show how to configure Batch macro. Unfortunately it outputs nothing, but I guess it works with your real data.

image.png

terrellchong
8 - Asteroid

Ran into a bit of a snag while trying to plug your macro into my current workflow. It looks like it's churning out way more row items than planned. To be precise, for tile number 1, I expected around 588 items, but the macro is going wild and generating a whopping 225,000 rows of data.

 

I'm starting to think I might be missing something about how this macro operates. My aim is to have all the tile number 1 items go through the data flow and then have the whole process kick off again in a loop.

 

Any insights or advice on what might be causing this row item overload? Maybe there's a setting I need to tweak?

gawa
16 - Nebula
16 - Nebula

Without seeing your data, I cannot specifically advise more.

Any chance of sharing  a kind of sample file?

terrellchong
8 - Asteroid

Please find the attached sample input and output

gawa
16 - Nebula
16 - Nebula

@terrellchong 

Thank you for providing data, now I see it. Please try attached WF again. 

 

When Control parameter is used, you need to input unique value for Control group to "?" anchor. So in this case, I put Summarize tool to create unique value of "Tile_Num". It iterates the same number of input records to "?" anchor. In this case, it's 2 iterations.

image.png

Labels
Top Solution Authors