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
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