Append one column to another dataset

[wonka1234]

Hi,

I want to append column from another data to the above screenshot

so action required should be a column in my above screenshot.

[Felipe_Ribeir0]

Hi @wonka1234 

Do you have some column that is common between both datasets and that could be used as a key to link them? This is necessary to assign the value from the second dataset to the correct row of the first dataset.

[wonka1234]

Yes both datasets have an "ID1" and "ID2" .. both together would probably work. Tried joining on these, the inner result gives me more records then the inputs. Ie Input 10 records from left, input 10 records from right, output is 15 records

[Felipe_Ribeir0]

@wonka1234 Ok, it is hard to say that it gonna work without seeing the data, but if the ID1 field is on both tables and it is unique on the second table, you could try something like this:

[wonka1234]

not unique =[ there are about 5 duplicates in both datasets. the datasets are identifcal except for the last columnon each

[ikrimachoudry]

Hi there. 
I have two different datasets.

And I want to add just the last column, from the second dataset(Size name)  to the first dataset.( Item) 
Which tool is required here? 
thanks