Clear Filters
Clear Filters

error using the join function

4 views (last 30 days)
Wesso
Wesso on 21 Aug 2023
Edited: Stephen23 on 21 Aug 2023
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?

Answers (2)

Stephen23
Stephen23 on 21 Aug 2023
Edited: Stephen23 on 21 Aug 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 on 21 Aug 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)

Categories

Find more on MATLAB in Help Center and File Exchange

Tags

Products


Release

R2022a

Community Treasure Hunt

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

Start Hunting!