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