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

Configuration

aggregate

Last modified 9mo ago

Export as PDF

Copy link

Contents

Syntax

Reference