join within a array
EdBerth
Dataiku DSS Core Designer, Dataiku DSS Adv Designer, Registered Posts: 15 ✭✭✭
Hello,
Is it possible to join datasets using an array or list attributein one of these datasets ?
I have a dataset with a list type attribute, I want to keep only the rows whose this attribute contains certain values. these values are in a second dataset
for example :
dataset n°1
Name | ids
AA | 12;54
BB | 22;100
CC | 56;100
dataset n°2
Id
12
56
and i'd like AA and CC in output
Best Answer
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,323 NeuronYou could use the split function to separate the list of attributes in different columns. Then use a normal join with all the columns. Another option is to do it in a Python recipe.
