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

Answer 1

[Ankriti Sachan]

Based on my understanding, you can do the following:

1. Convert the matrices to the tables - https://www.mathworks.com/help/matlab/ref/array2table.html.
2. 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.

[Peter Perkins]

It sounds like this would specificaly be innerjoin.