innerjoin invalid parameter name

6 Ansichten (letzte 30 Tage)
Wesso
Wesso am 15 Feb. 2019
Bearbeitet: Matt J am 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?

Akzeptierte Antwort

Matt J
Matt J am 15 Feb. 2019
Bearbeitet: Matt J am 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);

Weitere Antworten (0)

Kategorien

Mehr zu Tables finden Sie in Help Center und File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by