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), or

Data > Get External Data > Statistica Extract, Transform, and Load (ETL), 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 is 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.

Element Name Element Type Description
Add data source Button 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 Button 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 Option button 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 Option button 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 Option button 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 Option button 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 Option button 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:

Element Name Description
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