Using a dataset to segment data
Options
PhilippeDulac
Registered Posts: 11 ✭✭✭
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
Best Answer
-
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 !
Answers
-
Perfect !
Exactly what I was expecting.
Thanks a lot Wlukusa