Survey banner
The Dataiku Community is moving to a new home! We are temporary in read only mode: LEARN MORE

join within a array

Solved!
EdBerth
Level 3
join within a array

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 

 

 

0 Kudos
1 Solution
Turribeach

You 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. 

 

Screenshot 2023-08-24 at 13.44.02.png

 

 

 

View solution in original post

0 Kudos
1 Reply
Turribeach

You 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. 

 

Screenshot 2023-08-24 at 13.44.02.png

 

 

 

0 Kudos

Labels

?

Setup info

?
A banner prompting to get Dataiku