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

How to join a ranking list with a certain field.

pbazargani
Alteryx Alumni (Retired)

Hi, I'm working on a project where I'm trying to find the top ranked institutions for masters degrees. One of my data sources has the names of the programs and another that has the ranking of the institutions.

 

Which join tool should I use and how can I use it to obtain a list of the top ranked masters programs.

I provided images of the workflows I have below.

 

 

2 REPLIES 2
digitalmemo
8 - Asteroid

Hi. Is your list of institution already ranked in that manner from your image? I'd add a RecordID to your institutions list that would serve as their ranking then join to 2 datasets on INSTNM followed by a Sort tool asc on RecordID field after the Join tool.

pbazargani
Alteryx Alumni (Retired)

Thank You, this worked out really well!

Labels