Statistica ETL: ID-Based Startup Panel and Quick Tab

ID-Based Statistica ETL aggregates data from multiple data sources based on an identifier variable (either number or text) and an optional time variable. If a time variable is defined, data may be optionally aligned by N equal intervals or N user-specified intervals.

Ribbon bar. Select the File tab. Click External Data. Under Extract, Transform, and Load (ETL), click ID-based and Batch Data, or:

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

Select the Enterprise tab. In the Data group, click Extract, Transform, and Load (ETL) and on the menu, select ID-based and Batch Data.

Classic menus. Select ID-based and Batch Data on the:

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

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

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

The Statistica Extract, Transform, and Load (ETL): ID-based dialog box will be displayed, which contains two tabs: Quick and Advanced.

Quick Tab

The Quick tab contains the most commonly used ID-Based Statistica ETL options.

The grid at the top lists the data sources and their associated properties such as data source ID (for recording/editing SVB macros), data type, and data 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 ID and output variables. If you also select one or more optional Time variable(s), then the Time Variable Specs button is enabled.

Statistica Extract, Transform, and Load (ETL) Dialog Box

The following buttons are always available whether the Quick or Advanced 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.