Problem 2252. Create matrix with common dates from a number of structs -inner join on dates
Do an "inner join" (as in SQL) on a number of structs where the ".date" is the date and the ".ts" the timeseries. The join is on common dates and the result is a matrix which has as first column the common dates and the following columns are the data points from the matrices. For example n=2
X(1).date=[73502 73503 73504 73505 73506 73507]; X(1).ts=[100 101 102 102 101 100];
X(2).date=[73503 73504 73506 73507 73508]; X(2).ts=[101 99 100 98 99];
Resulting into a matrix with n+1 columns
Y=[73503 101 101; 73504 102 99; 73506 101 100; 73507 100 98]
The number n is the number of datasets X(1) ... X(n)
Solution Stats
Problem Comments
Solution Comments
Show commentsProblem Recent Solvers15
Suggested Problems
-
First non-zero element in each column
939 Solvers
-
Find the sum of the elements in the "second" diagonal
1199 Solvers
-
568 Solvers
-
790 Solvers
-
Who has power to do everything in this world?
481 Solvers
Problem Tags
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!