Merging tables with partly the same column names, but sometimes different dimensions
14 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
James Johnson
le 21 Déc 2022
Modifié(e) : Bora Eryilmaz
le 21 Déc 2022
Hi,
I have two tables with partly the same variable names. I want to merge these together and put them underneath each other, with all values of each variable under each other and empty cases for variables that are not present in the one table.
How can I do this?
Thank you!
0 commentaires
Réponse acceptée
Bora Eryilmaz
le 21 Déc 2022
Modifié(e) : Bora Eryilmaz
le 21 Déc 2022
This seems like a table (outer) join problem. Take a look at: https://www.mathworks.com/help/matlab/ref/table.outerjoin.html
Tleft = table({'a' 'b' 'c'}', [1 2 3]', 'VariableNames', {'Key1' 'Var1'})
Tright = table({'a','b','d'}', [4 5 6]', 'VariableNames', {'Key1' 'Var2'})
T = outerjoin(Tleft, Tright, 'MergeKeys', true)
0 commentaires
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Whos dans Help Center et File Exchange
Produits
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!