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

​aggregate​

Reduce the number of rows in a DSET while preserving information

​append​

Append one DSET to the end of another

​calculate​

Perform arithmetic on column values

​capitalise capitalize​

Capitalise column name and/or values

​convert​

Convert between decimal and hex values

​copy​

Copy rows from one DSET to another

​correlate​

Merge DSETs using a key

​create​

Create one or more columns

​default​

Specify the default DSET

​delete​

Delete columns, rows or DSETs

​event_to_usage​

Generate usage records from consumption START/STOP events

​export​

Snapshot a DSET to disk

​finish​

Create a Reporting Database File

​if​

Conditionally execute statements

​import use​

Import a Dataset or CCR file

​include​

Execute one task from within another

​lowercase​

Convert column name and/or values to lower case

​move​

Move rows from one DSET to another

​normalise normalize​

Normalise strings

​option​

Set global parameters

​rename​

Rename an existing column or DSET

​replace​

Search and replace values in a column

​round​

Round numeric values in a column

​service​

Create a chargeable service

​services​

Create multiple chargeable services

​set​

Set cell values in a column

​split​

Split column values

​timecolumns​

Set the start time and end time columns

​timerender​

Render a UNIX timestamp in human-readable form

​timestamp​

Create a timestamp column

​use​

See import

​update_service​

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

​uppercase​

Convert column name and/or values to upper case

​var​

Define a variable

​where​

Define a local filter