Commands in this group perform different operations on fields, records, or tables – the core items used to organize and display data in Analytics.

Command Description

ACTIVATE

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.

DEFINE COLUMN

Creates and adds one or more columns to an existing view.

DEFINE FIELD

Defines a physical data field in an Analytics table layout.

DEFINE FIELD...COMPUTED

Defines a computed field in an Analytics table layout.

DEFINE REPORT

Creates a new view or opens an existing view.

DEFINE VIEW

Defines a new view or overwrites an existing view.

EXTRACT

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.

FIELDSHIFT

Shifts the start position of a field definition in a table layout.

FIND

Searches an indexed character field for the first value that matches the specified character string.

IMPORT LAYOUT

Imports an external table layout file (.layout) to an Analytics project.

LIST

Outputs the data in one or more fields in an Analytics table to a display formatted in columns.

LOCATE

Searches for the first record that matches the specified value or condition, or moves to the specified record number.

NOTES

Creates, modifies, or removes a note associated with an individual record in an Analytics table.

OPEN

Opens an Analytics table and the associated data file.

REFRESH

Updates the data in an Analytics table from its associated data source.

SAVE

Copies an Analytics table and saves it with a different name, or saves an Analytics project.

SAVE LAYOUT

Saves an Analytics table layout to an external table layout file (.layout), or saves table layout metadata to an Analytics table.

SAVE TABLELIST

Saves a list of all tables in an Analytics project to an Analytics table or a CSV file.

SAVE WORKSPACE

Creates and saves a workspace.

SEEK

Searches an indexed character field for the first value that matches the specified character expression or character string.

SPLITVALUES

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.

TOP

Moves to the first record in an Analytics table.