Create a Virtual Table

Use this page to create a virtual table that is based on a standard table that contains a TimeSeries subtype.

A virtual table is a relational table with the same schema as the base table, except for the TimeSeries column. The TimeSeries column is replaced with the columns of the TimeSeries subtype. The elements in the TimeSeries column are individual columns in the virtual table. The virtual table contains all the data that is in the base table, including the data that is encapsulated in the TimeSeries subtype.

TimeSeries Column

Select the TimeSeries column in the base table to base this virtual table on.

Allow duplicates

Select this option to allow multiple elements at the same timepoint. By default, if an element exists at a timepoint, the new element replaces the existing element. If you allow duplicates, you can perform bulk updates of the underlying time series.

Show null elements

Select this option to show null elements as a row of null values, plus the timestamp column and any other columns from the base table. By default, if a regular time series has a null element, the virtual table has no entries for that element.

Show hidden elements

Select this option to show hidden elements in the virtual table. By default, if a regular time series has a hidden element, the virtual table has no entries for that element.