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.

Element Name Description
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 tab or Advanced 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

For more information, see also Statistica Extract, Transform, and Load (ETL) Overview.