For and while loop on a table

Alteryxnewbie27

Hello All,

I am new to Alteryx , trying to implement for and while loop together on 2 fields in a table. Could somebody please help me with this.

Goal is to run a loop on table 1 and get table 2 as output. Am trying to run a for loop on Act field, count the number of rows between N to N , average the Volume field for the same number of rows. Repeat the same until the last row of the Act field.

Datasets

Batch Macro

Iterative Macro

Accepted answers

Hi @Alteryxnewbie27

One way of doing this

For and while loop on a table.yxmd

All comments

hey @Alteryxnewbie27

I believe you could achieve this result using the summarize tool.

See attached for a sample using a similar dataset as your screenshot!

Hope this helps! Please mark this post as a solution if it answered your questions.

New Workflow6.yxmd

Hi @Alteryxnewbie27

One way of doing this

For and while loop on a table.yxmd

I agree with @Felipe_Ribeir0 that a multirow tool is the way to go

Create Groups with Multirow Tool.yxmd

Alteryxnewbie27

@ Felipe_Ribeir0, Thanks for you help. It worked!!

muhammadimranhakimi

Thanks for the discussion!

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703