Innerjoin of two tables

2 visualizaciones (últimos 30 días)
Dion Theunissen
Dion Theunissen el 3 de Feb. de 2022
Respondida: Nitin Khola el 3 de Feb. de 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.

Respuestas (1)

Nitin Khola
Nitin Khola el 3 de Feb. de 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:

Categorías

Más información sobre Tables en Help Center y File Exchange.

Productos


Versión

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by