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
-
5259 Solvers
-
1496 Solvers
-
Matrix with different incremental runs
475 Solvers
-
142 Solvers
-
Is this triangle right-angled?
5158 Solvers
Problem Tags
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!