Alteryx designer Discussions

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

Data grouping issue

Highlighted
Atom

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
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

Highlighted
Atom

 @wdavis Thank you this works !!!

Labels