Using a dataset to segment data

PhilippeDulac

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

wlukusa

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 !

PhilippeDulac

Perfect !

Exactly what I was expecting.

Thanks a lot Wlukusa