# 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 `[`**`like`***`this`*`]` * 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](https://olddocs.exivity.io/3.4.3/advanced/digging-deeper/dataset-lifecycle) 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](https://olddocs.exivity.io/3.4.3/data-pipelines/transform/language/aggregate) | Reduce the number of rows in a DSET while preserving information | | [append](https://olddocs.exivity.io/3.4.3/data-pipelines/transform/language/append) | Append one DSET to the end of another | | [calculate](https://olddocs.exivity.io/3.4.3/data-pipelines/transform/language/calculate) | Perform arithmetic on column values | | [capitalise](https://olddocs.exivity.io/3.4.3/data-pipelines/transform/language/capitalise) [capitalize](https://olddocs.exivity.io/3.4.3/data-pipelines/transform/language/capitalise) | Capitalise column name and/or values | | [convert](https://olddocs.exivity.io/3.4.3/data-pipelines/transform/language/convert) | Convert between decimal and hex values | | [copy](https://olddocs.exivity.io/3.4.3/data-pipelines/transform/language/copy) | Copy rows from one DSET to another | | [correlate](https://olddocs.exivity.io/3.4.3/data-pipelines/transform/language/correlate) | Merge DSETs using a key | | [create](https://olddocs.exivity.io/3.4.3/data-pipelines/transform/language/create) | Create one or more columns | | [default](https://olddocs.exivity.io/3.4.3/data-pipelines/transform/language/default) | Specify the default DSET | | [delete](https://olddocs.exivity.io/3.4.3/data-pipelines/transform/language/delete) | Delete columns, rows or DSETs | | [event\_to\_usage](https://olddocs.exivity.io/3.4.3/data-pipelines/transform/language/event_to_usage) | Generate usage records from consumption START/STOP events | | [export](https://olddocs.exivity.io/3.4.3/data-pipelines/transform/language/export) | Snapshot a DSET to disk | | [finish](https://olddocs.exivity.io/3.4.3/data-pipelines/transform/language/finish) | Create a Reporting Database File | | [if](https://olddocs.exivity.io/3.4.3/data-pipelines/transform/language/if) | Conditionally execute statements | | [import](https://olddocs.exivity.io/3.4.3/data-pipelines/transform/language/import) [use](https://olddocs.exivity.io/3.4.3/data-pipelines/transform/language/import) | Import a Dataset or CCR file | | [include](https://olddocs.exivity.io/3.4.3/data-pipelines/transform/language/include) | Execute one task from within another | | [lowercase](https://olddocs.exivity.io/3.4.3/data-pipelines/transform/language/lowercase) | Convert column name and/or values to lower case | | [move](https://olddocs.exivity.io/3.4.3/data-pipelines/transform/language/copy) | Move rows from one DSET to another | | [normalise](https://olddocs.exivity.io/3.4.3/data-pipelines/transform/language/normalise) [normalize](https://olddocs.exivity.io/3.4.3/data-pipelines/transform/language/normalise) | Normalise strings | | [option](https://olddocs.exivity.io/3.4.3/data-pipelines/transform/language/option) | Set global parameters | | [rename](https://olddocs.exivity.io/3.4.3/data-pipelines/transform/language/rename) | Rename an existing column or DSET | | [replace](https://olddocs.exivity.io/3.4.3/data-pipelines/transform/language/replace) | Search and replace values in a column | | [round](https://olddocs.exivity.io/3.4.3/data-pipelines/transform/language/round) | Round numeric values in a column | | [service](https://olddocs.exivity.io/3.4.3/data-pipelines/transform/language/service) | Create a chargeable service | | [services](https://olddocs.exivity.io/3.4.3/data-pipelines/transform/language/services) | Create multiple chargeable services | | [set](https://olddocs.exivity.io/3.4.3/data-pipelines/transform/language/set) | Set cell values in a column | | [split](https://olddocs.exivity.io/3.4.3/data-pipelines/transform/language/split) | Split column values | | [timecolumns](https://olddocs.exivity.io/3.4.3/data-pipelines/transform/language/timecolumns) | Set the start time and end time columns | | [timerender](https://olddocs.exivity.io/3.4.3/data-pipelines/transform/language/timerender) | Render a UNIX timestamp in human-readable form | | [timestamp](https://olddocs.exivity.io/3.4.3/data-pipelines/transform/language/timestamp) | Create a timestamp column | | [use](https://olddocs.exivity.io/3.4.3/data-pipelines/transform/language/import) | See **`import`** | | [update\_service](https://olddocs.exivity.io/3.4.3/data-pipelines/transform/language/update_service) | Modify one or more existing [service](https://olddocs.exivity.io/3.4.3/getting-started/introduction/services-introduction#an-introduction-to-services) descriptions and/or unit label | | [uppercase](https://olddocs.exivity.io/3.4.3/data-pipelines/transform/language/uppercase) | Convert column name and/or values to upper case | | [var](https://olddocs.exivity.io/3.4.3/data-pipelines/transform/language/var) | Define a variable | | [where](https://olddocs.exivity.io/3.4.3/data-pipelines/transform/language/where) | Define a local filter |