MATLAB: Horizontally join two datasets of different sizes based on a common field

concatenatejoin;

Dear all,
I have two matrices (A and B) that I want to join together horizontally based on a common field to create an output as shown in C. I have included a small example of my very large datasets:
A=
        3304  1  329  0
        3304  1  819  0
        3304  2  76  0
        3304  1  12  0
        3304  2  971  1
        3304  1  76  2
        3304  2  230  2
        3304  1  258  2
        3304  1  27  3
        3304  1  73  3
        3304  2  179  3
        3304  3  190  3
B=
0  29.7  27.7  13.2
1  26.3  24.3  14.1
2  28.1  26.1  24.5
3  27.1  25.1  13.1
C=
3304  1  329  0  0  29.7  27.7  13.2
3304  1  819  0  0  29.7  27.7  13.2
3304  2  76  0  0  29.7  27.7  13.2
3304  1  12  0  0  29.7  27.7  13.2
3304  2  971  1  1  26.3  24.3  14.1
3304  1  76  2  2  28.1  26.1  24.5
3304  2  230  2  2  28.1  26.1  24.5
3304  1  258  2  2  28.1  26.1  24.5
3304  1  27  3  3  27.1  25.1  13.1
3304  1  73  3  3  27.1  25.1  13.1
3304  2  179  3  3  27.1  25.1  13.1
3304  3  190  3  3  27.1  25.1  13.1
I have spent many hours on this what I imagine is a very simple task, so any help would be appreciated.

Best Answer

C = [A B(A(:,4)+1, :)];
Related Question