error using the join function

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?

Respuestas (2)

Stephen23
Stephen23 el 21 de Ag. de 2023
Editada: Stephen23 el 21 de Ag. de 2023
"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:
Dyuman Joshi
Dyuman Joshi el 21 de Ag. de 2023
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)

Categorías

Más información sobre Data Type Conversion en Centro de ayuda y File Exchange.

Productos

Versión

R2022a

Etiquetas

Preguntada:

el 21 de Ag. de 2023

Editada:

el 21 de Ag. de 2023

Community Treasure Hunt

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

Start Hunting!

Translated by