Mergin matrixes with multiple identifiers
显示 更早的评论
Hi
I have two (or several matrices), which are datasets with an identifier for year and company, and then they have different data. One of the matrix have more data on each unique year and firm, and the other only has one observation for each year and firm, and some year / firm can be represented in only one of the matrixes.
So i need to link these matrixes together, so the year/firm that is not represented in both matrices are removed, and if there is more observations in matrix A with same year/firm it will have the data from matrix B repeated each time that year / firm is represented in matrix A.
Is there any function that can do this or do i have to run through alot of loops / if statements or what's the approach?
If needed i can provide the data :-)
Best regards,
Oskar
采纳的回答
Ankriti Sachan
2020-10-29
0 个投票
Based on my understanding, you can do the following:
- Convert the matrices to the tables - https://www.mathworks.com/help/matlab/ref/array2table.html.
- Perform 'join' operation on the tables - https://www.mathworks.com/help/matlab/ref/table.join.html.
If this does not help, please provide an example to help me understand the query better.
1 个评论
Peter Perkins
2020-11-20
It sounds like this would specificaly be innerjoin.
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Logical 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
