innerjoin invalid parameter name
4 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Wesso
el 15 de Feb. de 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?
0 comentarios
Respuesta aceptada
Matt J
el 15 de Feb. de 2019
Editada: Matt J
el 15 de Feb. de 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);
0 comentarios
Más respuestas (0)
Ver también
Categorías
Más información sobre Tables en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!