Merge two matrices of different length with respect to a date

Hi,

I want to merge these two datasets. It is slightly different with this one: https://uk.mathworks.com/matlabcentral/answers/316710-can-i-merge-two-matrices-of-different-length-with-respect-to-a-date-column-contained-in-both

Instead of trying to get the combination of the two based on the shortest length, I want to instead maintain the longest matrix and give a NaN values for the shortest matrix. This is my data:

A = [
        2000           1
        2001           1
        2002           1
        2003           1
        2004           1
        2005           1
        2006           1
        2007           1
        2008           1
        2009           1
        2010           1    
];

B = [
        2005           3
        2006           3
        2007           3
        2008           3
        2009           3
        2010           3
];

I am expecting the output to be like this one below:

AB = [
        2000           1        NaN
        2001           1        NaN
        2002           1        NaN
        2003           1        NaN
        2004           1        NaN
        2005           1        3
        2006           1        3
        2007           1        3
        2008           1        3
        2009           1        3
        2010           1        3
];

How can we do this?

Answer 1

[Andrei Bobrov]

AB = outerjoin(array2table(A,'v',{'years','dataA'}),...
    array2table(B,'v',{'years','dataB'}),'MergeKeys',true)

[BeeTiaw]

Thank you! this one works like magic.