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