join within a array

[EdBerth]

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 

[Turribeach · Accepted solution]

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.