error using the join function

Question

Wesso 2023-8-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2010762-error-using-the-join-function

编辑： Stephen23 2023-8-21

FinalData = join(All,M4,'Keys','ID','Year');

% I want to join All and M4 based on the common variables ID and Year. I want all columns of All and the additional columns of B when there is a match based on ID and Year. I am receiving an error :

Error using tabular/join Wrong number of arguments.

What went wrong?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Stephen23 2023-8-21

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2010762-error-using-the-join-function#answer_1290257

编辑：Stephen23 2023-8-21

在 MATLAB Online 中打开

"What went wrong?"

You need to provide multiple key names as one input argument, not as two separate input arguments. This means simply providing the key names as character vectors in a cell array:

FinalData = join(All,M4,'Keys',{'ID','Year'});
%                              ^           ^

This is explained in the JOIN documentation:

https://www.mathworks.com/help/matlab/ref/table.join.html#d124e1558433

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 2

Dyuman Joshi 2023-8-21

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2010762-error-using-the-join-function#answer_1290262

在 MATLAB Online 中打开

The corrext syntax is -

FinalData = join(All,M4,'Keys',{'ID','Year'}); 
%or
FinalData = join(All,M4,'Keys',["ID","Year"]);

Refer to the documentation page of join for more information.

If after making this correction, you still get an error, please attach your code (using the paperclip button) and copy and paste the full error message (i.e. all of the red text)