Commands in this group perform different operations on fields, records, or tables – the core items used to organize and display data in Analytics.
Command descriptions
Command | Description |
---|---|
Adds field definitions stored in an Analytics workspace to the existing set of field definitions in an Analytics table layout. |
|
CREATE LAYOUT |
Creates an empty Analytics table layout, which may be required in certain scripting situations. |
Creates and adds one or more columns to an existing view. |
|
Defines a physical data field in an Analytics table layout. |
|
Defines a computed field in an Analytics table layout. |
|
Creates a new view or opens an existing view. |
|
Defines a new view or overwrites an existing view. |
|
Extracts data from an Analytics table and outputs it to a new Analytics table, or appends it to an existing Analytics table. You can extract entire records or selected fields. |
|
Shifts the start position of a field definition in a table layout. |
|
Searches an indexed character field for the first value that matches the specified character string. |
|
Imports an external table layout file (.layout) to an Analytics project. |
|
Outputs the data in one or more fields in an Analytics table to a display formatted in columns. |
|
Searches for the first record that matches the specified value or condition, or moves to the specified record number. |
|
Creates, modifies, or removes a note associated with an individual record in an Analytics table. |
|
Opens an Analytics table and the associated data file. |
|
Updates the data in an Analytics table from its associated data source. |
|
Copies an Analytics table and saves it with a different name, or saves an Analytics project. |
|
Saves an Analytics table layout to an external table layout file (.layout), or saves table layout metadata to an Analytics table. |
|
Saves a list of all tables in an Analytics project to an Analytics table or a CSV file. |
|
Creates and saves a workspace. |
|
Searches an indexed character field for the first value that matches the specified character expression or character string. |
|
Splits a table into two or more tables based on unique values in a key field. Output tables use the unique value as the table name, with an optional text prefix. |
|
Moves to the first record in an Analytics table. |