Using a dataset to segment data

Solved!
PhilippeDulac
Level 1
Using a dataset to segment data

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 categoryminmax
A010
B1120
C2130
D3145

 

My_data dataset :

NameageCategory
XXX8A
YYY22C

 

What is the best way to determine category in my_data ?

 

Thanks in advance for your help,

 

Philippe

 

 

0 Kudos
1 Solution
wlukusa
Dataiker

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.

 
 
 

Capture d’écran 2020-12-10 à 18.52.06.png

 

Hope this helps ! 

View solution in original post

2 Replies
wlukusa
Dataiker

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.

 
 
 

Capture d’écran 2020-12-10 à 18.52.06.png

 

Hope this helps ! 

PhilippeDulac
Level 1
Author

Perfect !

Exactly what I was expecting.

Thanks a lot Wlukusa

0 Kudos