join two dataset with different schema
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
Tagged:
Answers
-
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?