Merging tables with partly the same column names, but sometimes different dimensions
19 views (last 30 days)
Show older comments
James Johnson
on 21 Dec 2022
Edited: Bora Eryilmaz
on 21 Dec 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 Comments
Accepted Answer
Bora Eryilmaz
on 21 Dec 2022
Edited: Bora Eryilmaz
on 21 Dec 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 Comments
More Answers (0)
See Also
Categories
Find more on Whos in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!