innerjoin invalid parameter name

Question

Wesso 2019-2-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/445195-innerjoin-invalid-parameter-name

编辑： Matt J 2019-2-15

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 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Matt J 2019-2-15

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/445195-innerjoin-invalid-parameter-name#answer_361242

编辑：Matt J 2019-2-15

在 MATLAB Online 中打开

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