join two dataset with different schema

Tong
Tong Registered Posts: 14 ✭✭✭✭

Hello,

I have two datasets, both have the "filename" as the join-key, but they have different schema

dataset-1 has 300 rows for one key (filename)

dataset-2 has only one row for one key (filenmae)

now I would like to join both datasets —> the value of one key from dataset-2 will be duplicated 300 times to fill the colume of "mass" and "ID" to get the one joined file.

the recipe "left join" did not work. I tried also other recipes, no success.

Does anyone have an idea? thanks!

dataset-1

dataset_2

Answers

  • Turribeach
    Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 1,993 Neuron

    The Join recipe should do this without problems. When you say “it did not work” you really didn’t give us much to work on. Please describe exactly what you mean by “did not work”. Do you get N error? Is the output incorrect? Why?

Setup Info
    Tags
      Help me…