Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Added on August 24, 2023 11:31AM
Likes: 0
Replies: 1
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
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.