Alteryx Designer Desktop Discussions

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

Value to be matched from one dataset to closest lower value in another set

Hi!

I have 2 datasets. In one there is a group of "badges" and how many points do we need to achieve that badge

Another dataset is how many points did one person achieve.

How could I join these two datasets? I.e If I have myself at for example 98 points, how can I match myself from another dataset, where for example I need 90 points to get a badge?

I attached yxzp as an example.

Thank you. 

4 REPLIES 4
PhilipMannering
16 - Nebula
16 - Nebula

Hey @lalalalalalalalalala 

 

Here's one solution....

PhilipMannering_0-1633351497663.png

 

I think the file you attached is just my file, not the updated one. Would you be able to attach your version as well as the yxzp file?

Christina_H
14 - Magnetar

Here's my version

Christina_Hurrell_0-1633352282539.png

 

PhilipMannering
16 - Nebula
16 - Nebula

Apologies @lalalalalalalalalala  

See attached. Actuallly @Christina_H 's looks like a neater solution

 

Labels