The Transform tool is a multi-purpose tool that can be used to change both text and numeric columns. Its purpose is to format the given column into a certain shape, such as making a text column UPPERCASE or rounding a decimal columns to 2 decimals.Documentation Index
Fetch the complete documentation index at: https://docs.less.tech/llms.txt
Use this file to discover all available pages before exploring further.
Configuration
Select Column(s)
Select the column(s) you want to transform. You can choose multiple columns at the same time.
Select Transformation
Choose how you would like to change your column(s) from the options below:
| Option | Description | Column format requirement |
|---|---|---|
| Upper Case | CHANGES COLUMN CONTENT TO UPPERCASE | Text |
| Lower Case | changes column content to lowercase | Text |
| Title Case | Changes Column Content To Titlecase | Text |
| Left | Get the first x number of characters of a column | Text |
| Right | Get the last x number of characters of a column | Text |
| Length | Set the maximum x number of characters of a column | Text |
| Round | Round a numeric column to x number of decimals | Numeric |
| Ceil | Round up to nearest integer/whole number | Numeric |
| Floor | Round down to nearest integer/whole number | Numeric |
| Trim | Remove trailing/leading whitespace and tabs | Text |
| Escape Special Characters | \n show tabs as \n | Text |
| Remove special characters | removeunderscoresthatusedtobebetweenwords | Text |
| Encode | Encode as either HEX or Base64 | Text |
| Decode | Decode as either HEX or Base64 | Text |