Alteryx Designer Discussions

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

'Tis the season to be spooky! Read our new blog, How Spooky is Your City? Mapping and Predicting Scary Stuff. In it, @SusanCS provides a fun glimpse into using data to figure out the creepy quotient of where you live! And don't forget to check out our Digital Costume Thread to get yourself in the mood for a candy binge!

SOLVED

Data grouping issue

Highlighted
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
Highlighted
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
6 - Meteoroid

 @wdavis Thank you this works !!!

Labels