Innerjoin of two tables

1 ビュー (過去 30 日間)
Dion Theunissen
Dion Theunissen 2022 年 2 月 3 日
回答済み: Nitin Khola 2022 年 2 月 3 日
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.

回答 (1 件)

Nitin Khola
Nitin Khola 2022 年 2 月 3 日
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:

製品


リリース

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by