Extract and append data
You can extract records or fields from one Analytics table and append them as a group to the end of another Analytics table. The records or fields must have an identical structure in the two tables. The two tables can be sorted or unsorted. The resulting combined table is considered unsorted.
Steps
- In the Navigator, open the table from which you want to extract records or fields.
- Select .
- On the Main tab, select one of the following:
- Record extracts entire records.
- View extracts all the fields in the current view.
Note
The number, selection, and order of the fields in the view must exactly match the number, selection, and order of fields in the target table’s table layout.
- Fields extracts a selection of individual fields.
- If you selected Fields, select the appropriate fields from the Extract
Fields list.
Tip
You can Ctrl+click to select multiple non-adjacent fields, and Shift+click to select multiple adjacent fields.
Note
The number, selection, and order of the fields you select must exactly match the number, selection, and order of fields in the target table’s table layout.
- In the To text box, specify the name of the target table.
- On the More tab:
- (Optional) To specify that only a subset of records are processed, select one of the options in the Scope panel.
- Click OK.
Extract dialog box options
The tables below provide detailed information about the options in the Extract dialog box.
Main tab
Options – Extract dialog box | Description |
---|---|
Record View Fields |
Specifies the extraction method.
If you are extracting one or more computed fields:
Note You cannot append computed and physical fields to each other. For more information, see Extracting and appending computed fields. If you want to extract data from a child table in a table relation:
You cannot extract child table data using the Record option. |
Extract Fields |
If you selected Fields, specifies the fields to extract.
If you want to select fields from a child table in a table relation:
|
If |
(Optional) Allows you to create a condition to exclude records from processing. You can enter a condition in the If text box, or click If to create an IF statement using the Expression Builder. |
To |
Specifies the name and location of the target table.
You can also specify an absolute or relative file path, or navigate to a different folder, to append data to a target table in a location other than the project location. For example: C:\Results\GL_2011.fil or Results\GL_2011.fil. Regardless of where you append data, the target table is added to the open project if it is not already in the project. |
Local |
If you are connected to a server table, specifies where to save the output table.
|
Use Output Table | Specifies whether the Analytics table containing the output results opens automatically upon completion of the operation. |
More tab
Options – Extract dialog box | Description |
---|---|
Scope panel | Specifies which records in the source table are processed:
Note The number of records specified in the First or Next options references either the physical or the indexed order of records in a table, and disregards any filtering or quick sorting applied to the view. However, results of analytical operations respect any filtering. If a view is quick sorted, Next behaves like First. |
EOF (End of file processing) | (Optional) Forces the extract operation to execute one more time when the end
of a table is reached. The EOF parameter is usually used if you are extracting records as part of a larger analytic process and the Extract command occurs inside a group in a script. If you are extracting records based on a comparison between sequential records, you may need to use EOF to ensure the final record in a table is extracted. |
Append To Existing File |
Specifies that the output results are appended (added) to the end of an existing Analytics table.
Note Leaving Append To Existing File deselected is recommended if you are uncertain whether the output results and the existing table have an identical data structure. For more information about appending and data structure, see Appending results to Analytics tables and text files. |
OK | Executes the operation. If the overwrite prompt appears, select Append. If you are expecting the Append option to appear and it does not, click No to cancel the operation and see Appending results to Analytics tables and text files. |