MATLAB: Innerjoin invalid parameter name

Question

Hi,

I want to match table A with table B (they have different size) and I want to produce table C that keeps only the common rows.

A has the following variables 'DateAnnounced','TargetName',AcquirorName' that I want to match with the following variables from B:''DateAnnouncedb','TargetNameb','AcquirorFullName' respectively.

So I wrote the following codes:

    C=innerjoin(A,B,'DateAnnounced','DateAnnouncedb','TargetName','TargetNameb','AcquirorName','AcquirorFullName','LeftKeys',3,'RightKeys',3)

I received however the following error:

Error using tabular/innerjoin (line 94)

Invalid parameter name: DateAnnounced.

It is the first time I use innerjoin. Is my logic correct? if so why am I receiving the error?

Answer 1

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);