Azzera filtri
Azzera filtri

innerjoin invalid parameter name

1 visualizzazione (ultimi 30 giorni)
Wesso
Wesso il 15 Feb 2019
Modificato: Matt J il 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?

Risposta accettata

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

Più risposte (0)

Categorie

Scopri di più su Tables in Help Center e File Exchange

Tag

Community Treasure Hunt

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

Start Hunting!

Translated by