SOLVED
Value to be matched from one dataset to closest lower value in another set
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
lalalalalalalalalala
5 - Atom
‎10-04-2021
05:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
Labels:
- Labels:
- Join
- Spatial Analysis
4 REPLIES 4
16 - Nebula
‎10-04-2021
05:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎10-04-2021
05:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
‎10-04-2021
05:58 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
16 - Nebula
‎10-04-2021
06:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Apologies @lalalalalalalalalala
See attached. Actuallly @Christina_H 's looks like a neater solution
