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?

Antworten (2)

Stephen23
Stephen23 am 21 Aug. 2023
Bearbeitet: Stephen23 am 21 Aug. 2023

0 Stimmen

"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 am 21 Aug. 2023

0 Stimmen

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)

Kategorien

Produkte

Version

R2022a

Tags

Gefragt:

am 21 Aug. 2023

Bearbeitet:

am 21 Aug. 2023

Community Treasure Hunt

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

Start Hunting!

Translated by