Language

Syntax

Within the individual reference articles for each statement, the syntax is described using the following conventions:

  • bold for keywords

  • italics for arguments

  • Square brackets for optional keywords and arguments [likethis]

  • Vertical pipe for alternative keyword options just|exactly as shown

  • Ellipses for a variable length list of arguments: Column1 ... ColumnN

Refer to the core concepts page for more information regarding datasets, fully qualified column names and related information.

Reference

The following statements (in alphabetical order) are supported by Transcript:

Statement

Description

Reduce the number of rows in a DSET while preserving information

Append one DSET to the end of another

Perform arithmetic on column values

Capitalise column name and/or values

Convert between decimal and hex values

Copy rows from one DSET to another

Merge DSETs using a key

Create one or more columns

Specify the default DSET

Delete columns, rows or DSETs

Snapshot a DSET to disk

Create a Reporting Database File

Conditionally execute statements

Import a Dataset or CCR file

Execute one task from within another

Convert column name and/or values to lower case

Move rows from one DSET to another

Normalise strings

Set global parameters

Rename an existing column or DSET

Search and replace values in a column

Round numeric values in a column

Create a chargeable service

Create multiple chargeable services

Set cell values in a column

Split column values

Set the start time and end time columns

Render a UNIX timestamp in human-readable form

Create a timestamp column

See import

Modify one or more existing service descriptions and/or unit label

Convert column name and/or values to upper case

Define a variable

Define a local filter

Last updated