PROFILE command

Generates summary statistics for one or more numeric fields, or numeric expressions, in an Analytics table.

Syntax

PROFILE {<FIELDS> numeric_field <...n>|<FIELDS> ALL} <IF test> <WHILE test> <FIRST range|NEXT range>

Parameters

Name Description
FIELDS numeric_field <...n> | FIELDS ALL

Specify individual fields to profile, or specify ALL to profile all numeric fields in the Analytics table.

IF test

optional

A conditional expression that must be true in order to process each record. The command is executed on only those records that satisfy the condition.

Note

The IF parameter is evaluated against only the records remaining in a table after any scope parameters have been applied (WHILE, FIRST, NEXT).
WHILE test

optional

A conditional expression that must be true in order to process each record. The command is executed until the condition evaluates as false, or the end of the table is reached.

Note

If you use WHILE in conjunction with FIRST or NEXT, record processing stops as soon as one limit is reached.
FIRST range | NEXT range

optional

The number of records to process:

  • FIRST start processing from the first record until the specified number of records is reached
  • NEXT start processing from the currently selected record until the specified number of records is reached

Use range to specify the number of records to process.

If you omit FIRST and NEXT, all records are processed by default.

Examples

Profiling a single field

You profile the Salary field:

OPEN Employee_Payroll
PROFILE FIELDS Salary

The command generates the following output:

Field Name Total Value Absolute Value Minimum Maximum
SALARY 1,152,525 1,152,525 15,340 52,750

Remarks

Statistics displayed in output

The following statistics are displayed for each numeric field or numeric expression specified for the command:

  • total value
  • absolute value
  • minimum value
  • maximum value

[ Back to top ]

ACL Scripting Guide 14.1