databank.toTable
(+databank)
Retrieve time series from databank and arrange them in a table
Syntax
outputTable = databank.toTable(inputDb, ~names, ~dates, ...)
Input arguments
inputDb
[ struct | Dictionary ]
Input databank from which the time series (specified by their
names
) will be extracted.
~names=@all
[ string | @all
]
Names of time series that will be extracted from the
inputDb
;@all
means all time series found in theinputDb
.
~dates="unbalanced"
[ Dater | "unbalanced"
| "balanced"
]
Dates for which the time series observations will be retrieved, with the following four text specifications:
"unbalanced"
means a range from the earliest start date to the latest end date found amongst all the named time series;
"balanced"
means a range from the latest start date to the earliest end date found;
Output arguments
outputTable
[ table ]
Output table with the observations from the names time series at the specified dates organized in columns.
Options
zzz=default
[ zzz | ___ ]
Description
Description
Examples
d = struct( );
d.x = Series(qq(2020,1):qq(2025,4), @rand);
d.y = Series(qq(2021,1):qq(2025,1), @rand);
d.z = Series(qq(2020,3):qq(2026,1), @rand);