Analytics commands

Counts the number of times each leading digit (1–9) or leading digit combination occurs in a field, and compares the actual count to the expected count. The expected count is calculated using the Benford formula.

Counts the total number of records in the current view, or only those records that meet the specified condition.

Detects whether duplicate values or entire duplicate records exist in an Analytics table.

Detects nearly identical values (fuzzy duplicates) in a character field.

Detects whether a numeric or datetime field in an Analytics table contains one or more gaps in sequential data.

Identifies statistical outliers in a numeric field. Outliers can be identified for the field as a whole, or for separate groups based on identical values in one or more character, numeric, or datetime key fields.

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

Determines if one or more fields in an Analytics table are in sequential order, and identifies out-of-sequence items.

Calculates statistics for one or more numeric or datetime fields in an Analytics table.

Calculates the total value of one or more fields in an Analytics table.

Checks for data validity errors in one or more fields in an Analytics table by verifying that the data is consistent with the field definitions in the table layout.

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

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.

Groups records into aging periods based on values in a date or datetime field. Counts the number of records in each period, and also subtotals specified numeric fields for each period.

Groups records based on identical values in a character or numeric field. Counts the number of records in each group, and also subtotals specified numeric fields for each group.

Groups records into clusters based on similar values in one or more numeric fields. Clusters can be uni-dimensional or multidimensional.

Groups records based on identical combinations of values in two or more character or numeric fields, and displays the resulting groups in a grid of rows and columns. Counts the number of records in each group, and also subtotals specified numeric fields for each group.

Groups records based on values in a character or numeric field, counts the number of records in each group, and displays the groups and counts in a bar chart.

Identifies statistical outliers in a numeric field. Outliers can be identified for the field as a whole, or for separate groups based on identical values in one or more character, numeric, or datetime key fields.

Groups records into numeric intervals based on values in a numeric field. Counts the number of records in each interval, and also subtotals specified numeric fields for each interval.

Groups records based on identical values in one or more character, numeric, or datetime fields. Counts the number of records in each group, and also subtotals specified numeric fields for each group.

Combines records from two or more Analytics tables by appending them in a new Analytics table.

Defines a relation between two Analytics tables.

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.

Uses fuzzy matching to combine fields from two Analytics tables into a new, single Analytics table.

Combines fields from two Analytics tables into a new, single Analytics table.

Combines records from two sorted Analytics tables with an identical structure into a new Analytics table that uses the same sort order as the original tables.

Stratifies a population, and calculates a statistically valid sample size for each stratum, for classical variables sampling.

Draws a sample of records using the classical variables sampling method.

For classical variables sampling, provides four different methods for projecting the results of sample analysis to the entire population.

Calculates a statistically valid sample size, and sample interval, for record sampling or monetary unit sampling.

Draws a sample of records using either the record sampling or monetary unit sampling method.

For record sampling or monetary unit sampling, projects errors found in sampled data to the entire population, and calculates upper limits on deviation rate, or misstatement amount.

Adds field definitions stored in an Analytics workspace to the existing set of field definitions in an Analytics table 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.

SAVE TABLELIST

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.

Moves to the first record in an Analytics table.

Creates a dialog box that interactively prompts users for one or more script input values. Each input value is stored in a named character variable.

Creates a variable and assigns a value to the variable.

Calculates the value of one or more expressions.

Closes an Analytics table, index file, or log file, or ends a Script Recorder session.

Adds an explanatory note to a script without affecting processing.

Deletes an Analytics project item, a field from a table layout, a variable, one or more table history entries, a relation between tables, or a file in a Windows folder. Also removes a column from a view.

Creates a custom dialog box that interactively prompts users for one or more script input values. Each input value is stored in a named variable.

Executes a secondary script, or an external script, from within an Analytics script.

Terminates the script being processed, or all scripts, without exiting Analytics.

Executes an application or process external to Analytics. Emulates the Windows Run command. Can be used to interact with the Windows command prompt.

Executes one or more ACLScript commands on a record before moving to the next record in the table, with only one pass through the table. Command execution can be controlled by conditions.

Specifies a condition that must evaluate to true in order to execute a command.

Executes a series of ACLScript commands repeatedly on a record while a specified condition evaluates to true.

Sends an email notification message.

Creates a password definition, without a password value, that prompts users for a password while a script is running.

Pauses a script, and displays information in a dialog box for users.

Passes an Analytics table to an external R script as a data frame and creates a new table in the Analytics project using output from the external R script.

Renames an Analytics project item or a file.

Sets a configurable Analytics option.

Generates the specified Analytics report.

Prints a text file, an Analytics log file, or an Analytics project item that has been exported as an external file – a script (.aclscript), a table layout (.layout), or a workspace (.wsp). You can also print a graph that has been generated by a command.

Formats and generates a report based on the open Analytics table.

Generates a list of files and folders in the specified directory.

Displays information about the specified Analytics item type. Can also display the result of an expression, or the output of a function.

Displays the contents of a file, or the current record, in hexadecimal, ASCII, and EBCDIC character encodings.

Launches the Analytics Help Docs in a browser.

Ends the current session and closes Analytics.

Generates a set of random numbers.

Saves the entire command log, or the log entries for the current Analytics session, to an external file.