Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Data grouping issue

JuniorS
6 - Meteoroid

Hi want to assign the correct class and year to my data. From what it looks like on the right to the left. how do I go about this for a large file

 

yearclassstudent  yearclassstudent
1a1  1a1
  2  1a2
1b1  1b1
  2  1b2
  3  1b3
2a1  2a1
  2  2a2
2 REPLIES 2
wdavis
Alteryx
Alteryx

Hi @JuniorS 

 

This can be achieved by using a Multi-Row Formula which allows you to reference rows above and below your data.

 

The attached workflow should give you what you are looking to achieve. You can then apply this across all of your dataset.

 

Let me know if this works for you!

 

Thanks

Will

JuniorS
6 - Meteoroid

 @wdavis Thank you this works !!!

Labels