Statistica ETL: Time-Indexed Startup Panel and Quick Tab

Time-indexed Statistica ETL aggregates data from multiple data sources based on a date/time stamp variable. Data may be aligned by minute, hour, day, week, month, quarter, or year.

Ribbon bar. Select the File tab. Click External Data. Under Extract, Transform, and Load (ETL), click Time-indexed Process Data, or:

Select the Data tab. In the Manage group, click External Data and on the Extract, Transform, and Load (ETL) submenu, select Time-indexed Process Data, or:

Select the Enterprise tab. In the Data group, click Extract, Transform, and Load (ETL) and on the menu, select Time-indexed Process Data.

Classic menus. Select Time-indexed Process Data on the:

File - Get External Data - Statistica Extract, Transform, and Load (ETL) submenu, or

Data - Get External Data - Statistica Extract, Transform, and Load (ETL) submenu, or

Enterprise - Statistica Extract, Transform, and Load (ETL) submenu (if STATISTICA Enterprise is installed).

The Statistica Extract, Transform, and Load (ETL): Time-indexed Startup Panel will be displayed, which contains three tabs: Quick, Advanced, and Options.

Quick Tab

The Quick tab contains the most commonly used Time-Indexed Statistica ETL options.

The grid at the top of the tab lists the data sources and their associated properties such as data source ID (for recording/editing SVB macros), data type, and name. When your cursor hovers over a data source in the grid, a tool tip displays the full path of the data source location.

Add data source. Click this button to display the Select Data Sources dialog box, where you can specify a data source to add to the list.

Remove data source. Select a data source in the grid at the top of the tab and click this button to remove that data source from the grid.

Note: To change the sequence in which the data sources are aligned/merged, select a data source and click the arrow buttons at the side of the grid. Click the down arrow to demote the selected source; click the up arrow to promote the selected source.

Options/properties applicable to selected data source above. This option applies to the data source selected in the grid.

Variables. Click this button to display the Select Variables dialog box, where you select date/time and output variables.

Aggregation interval for all data source(s). The selected date/time interval aligns data across all defined data sources.

Minutes. When this option button is selected, the aggregation interval is minutes, starting from the minute specified. Limit of k minutes (1 k < 60).

Hours. This is the default aggregation interval. When selected, the aggregation interval is hours, starting from the hour specified. Limit of l hours (1 l < 24).

Days. When this option button is selected, the aggregation interval is days, starting from the day specified. Limit of m days (1 m 9999).

Weekly - start from. When this option button is selected, the aggregation interval is weeks, starting from the day of the week specified (i.e. Monday, Tuesday, Wednesday, etc.).

Monthly - start from. When this option button is selected, the aggregation interval is months, starting from the day of the month specified. Limit of 1 through 31.

Quarterly - start from. When this option button is selected, the aggregation interval is quarters, starting from the date specified. Limit of January 1 through December 31.

Annually - start from. When this option button is selected, the aggregation interval is years, starting from the date specified. Limit of January 1 through December 31.

Statistica Extract, Transform, and Load (ETL) Startup Panel

The following buttons are always available regardless of which tab is selected:

Results. Click this button to align data (across all data sources) into a standalone Statistica spreadsheet.

Note: As with other Statistica dialog boxes, Statistica ETL follows the self-prompting convention, which means that whenever you are not sure of what to select next, simply click the Results button to be prompted for the specific input needed (e.g., data sources and/or input variables).

Cancel. Click this button to end the analysis and close the Startup Panel.

Options. Click this button to display the Options menu.

Load Settings. Click this button to load a previously saved XML file.

Save Settings. Click this button to save the specifications that are defined in this dialog box in XML form.

See also Statistica Extract, Transform, and Load (ETL) Overview.