Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Hi,
I would like to associate a "category" to my data depending on values in a column and ranges defined on another dataset.
Categories definition dataset :
age category | min | max |
A | 0 | 10 |
B | 11 | 20 |
C | 21 | 30 |
D | 31 | 45 |
My_data dataset :
Name | age | Category |
XXX | 8 | A |
YYY | 22 | C |
What is the best way to determine category in my_data ?
Thanks in advance for your help,
Philippe
Hi @PhilippeDulac,
To achieve that, you may use the Join recipe to do a left join with your two datasets using condition on Age superior to your min and inferior to your max and keeping the column you want.
Hope this helps !
Hi @PhilippeDulac,
To achieve that, you may use the Join recipe to do a left join with your two datasets using condition on Age superior to your min and inferior to your max and keeping the column you want.
Hope this helps !
Perfect !
Exactly what I was expecting.
Thanks a lot Wlukusa