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.

[gautiergodard]

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.

[Felipe_Ribeir0 · Accepted solution]

Hi @Alteryxnewbie27 

One way of doing this

[mpizzorusso]

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

[Alteryxnewbie27]

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

[muhammadimranhakimi]

Thanks for the discussion!