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.
See also Statistica
Extract, Transform, and Load (ETL) Overview.