join within a array

Options
EdBerth
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
    Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 1,714 Neuron
    Answer ✓
    Options

    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

Setup Info
    Tags
      Help me…