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?

Réponses (2)

Stephen23
Stephen23 le 21 Août 2023
Modifié(e) : Stephen23 le 21 Août 2023

0 votes

"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 le 21 Août 2023

0 votes

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)

Catégories

Produits

Version

R2022a

Tags

Question posée :

le 21 Août 2023

Modifié(e) :

le 21 Août 2023

Community Treasure Hunt

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

Start Hunting!

Translated by