Hello everybody,
I'm trying to merge two datasets. One calculated, and one retrieved from data, given by:
A=dataset(Output(:,2),Output(:,1),'VarNames',{'x' 'v'}); B=dataset(datarest(:,x),datarest(:,v),'VarNames',{'x' 'v'});|which results in something in the form of: A = x v 1 5 2 7 4 8B = x v 2 6 3 7
In this, I want to use the x as keys, and merge it to get a dataset, which states v for every x. For this i'm using
C=join(A,B,'key',{'x' ' v' },'Type','outer','MergeKeys',true);
And the result is
C = x v 1 5 2 6 2 7 3 7 4 8
Where I want it to be:
C = x v 1 5 2 6 3 7 4 8
Thus specifying that if there are values with the same key present in A and B, I want the value of B to be in the matrix of C. I hope you understand the issue, and can help me with the answer.
Thanks in advance!
Best Answer