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.
Solved! Go to Solution.
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.
I agree with @Felipe_Ribeir0 that a multirow tool is the way to go
@ Felipe_Ribeir0, Thanks for you help. It worked!!
Thanks for the discussion!