MATLAB Answers

innerjoin invalid parameter name

3 views (last 30 days)
Wesso
Wesso on 15 Feb 2019
Edited: Matt J on 15 Feb 2019
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?

Accepted Answer

Matt J
Matt J on 15 Feb 2019
Edited: Matt J on 15 Feb 2019
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);

More Answers (0)

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by