General scripting and user interaction

The general scripting and user interaction commands let you structure and control the behavior of scripts. Some of the commands let you create scripts that interact with an application, process, or programming language external to Analytics, including Python, R, and AI models.

Command descriptions

Command Description

ACCEPT

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.

AICOMMAND

Supports natural-language data analysis by integrating Analytics with an external AI service.

ASSIGN

Creates a variable and assigns a value to the variable.

CALCULATE

Calculates the value of one or more expressions.

CLOSE

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

COMMENT

Adds an explanatory note to a script without affecting processing.

DELETE

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.

DIALOG

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.

DO SCRIPT

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

ESCAPE

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

EXECUTE

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

GROUP

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.

IF

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

LOOP

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

NOTIFY

Submits an outgoing email notification message to an SMTP mail server to be relayed to recipients.

PASSWORD

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

PAUSE

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

PYCOMMAND

Passes an Analytics table to an external Python script as a dataframe, and creates a new table in the Analytics project using the returned output from the Python script.

RCOMMAND

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

RENAME

Renames an Analytics project item or a file.

SET

Sets a configurable Analytics option.