Innerjoin of two tables

7 次查看（过去 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:
https://www.mathworks.com/help/matlab/ref/innerjoin.html?searchHighlight=innerjoin&s_tid=doc_srchtitle#btx2hll-1-Keys

类别

在 Help Center 和 File Exchange 中查找有关 Tables 的更多信息

标签

产品


版本

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by