Innerjoin of two tables

4 views (last 30 days)
Dion Theunissen
Dion Theunissen on 3 Feb 2022
Answered: Nitin Khola on 3 Feb 2022
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.

Answers (1)

Nitin Khola
Nitin Khola on 3 Feb 2022
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:

Categories

Find more on Tables in Help Center and File Exchange

Products


Release

R2021b

Community Treasure Hunt

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

Start Hunting!