Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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.
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.