Sort data

The sort commands provide two different methods for sorting records in Analytics. The INDEX command temporarily reorders an existing table. The SORT command produces a new table with physically reordered records.

Command descriptions

Command Description

INDEX

Creates an index for an Analytics table that allows access to the records in a sequential order rather than a physical order.

SORT

Sorts records in an Analytics table into an ascending or descending sequential order, based on a specified key field or fields. The results are output to a new, physically reordered Analytics table.