join two dataset with different schema

Tong

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

Turribeach

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?