MATLAB: Need help with innerjoin where innerjoin returns more rows than necessary

MATLAB

Hi, I am using innerjoin to join two tables A and B: C = innerjoin(A, B); A has 30 rows and B has 140 rows. After the join, the result C has 70 rows. How come? I am quite puzzled. I just wanted 30 rows as in table A with a few extra columns from B. Thanks for any help!

Best Answer

Just found what's wrong here. Table B has same rows multiple times.

Related Solutions

MATLAB: How to join 2 MATLAB tables based on similarity in values of first column

Your description is that of an innerjoin, not an outerjoin. It's unclear why any one of the join wouldn't work. You must be doing something wrong but you don't tell us what you did precisely.

innerjoin(A, B, 'Keys', 1)

However, I would recommend converting your tables to timetables, Then you can use synchronize instead.

synchronize(table2timetable(A), table2timetable(B), 'intersection')

MATLAB: Innerjoin invalid parameter name

It appears that you are attempting to do the following:

Akeys={'DateAnnounced','TargetName','AcquirorName'};
Bkeys={'DateAnnouncedb','TargetNameb','AcquirorFullName'};
    
C=innerjoin(A,B,'LeftKeys',Akeys, 'RightKeys',Bkeys);

Best Answer

Related Solutions

MATLAB: How to join 2 MATLAB tables based on similarity in values of first column

MATLAB: Innerjoin invalid parameter name

Related Question