Innerjoin of two tables

I try to combine two tables based on the PartitionKey.

Actually it is not working on the way im trying now:

% Import the data
UserData = readtable("/Users/apployee/Documents/Dion/SV/UserData.csv", opts);
% Import the data
User = readtable("/Users/apployee/Documents/Dion/SV/User.csv", opts);


new = innerjoin(User,UserData,'PartitionKey');

Both tables contains in the first column the PartitionKey which is in both tables the same.

Answer 1

[Nitin Khola]

Hi,

If "PartitionKey" is the only variable in common, you can simple use the two tables as inputs and it will use this common variable by default.

innerjoin(User,UserData)

If you want to specify keys, you must pass in as name-value pair arguments. The following doc link explains one such argument, there are more below it:

https://www.mathworks.com/help/matlab/ref/innerjoin.html?searchHighlight=innerjoin&s_tid=doc_srchtitle#btx2hll-1-Keys