List of functions on columns
This table defines all the functions you can perform on columns in
Talend Cloud Data Stewardship.
| Name | Category | Description |
|---|---|---|
| Negate value | boolean | Reverses the boolean value of cells from this column. |
| Concatenate with | columns | Merges the content of this column with another one, and displays the content in a new column. |
| Convert country names and codes | conversions | Converts a country name to an ISO-3166 country code (alpha-2, alpha-3 or numeric) or vice versa. |
| Convert distance | conversions | Converts distance measurement units. |
| Convert duration | conversions | Converts time duration measurement units. |
| Convert temperature | conversions | Converts temperature measurement units. |
| Clear on matching value | data cleansing | Clears cells that match the value. |
| Clear the cells with invalid values | data cleansing | Clears cells that contain a value recognized as invalid. |
| Delete the rows with empty cell | data cleansing | Deletes rows that have empty cells. |
| Fill cells with value | data cleansing | Fills cells from this column with a given value. |
| Fill empty cells with text | data cleansing | Fills empty cells from this column with a given value. |
| Fill invalid cells with value | data cleansing | Fills cells from this column with a given value. |
| Standardize value (fuzzy matching) | data cleansing | Replaces invalid values in the column with the closest correct value from the dictionary-bases semantic type referenced by the column. |
| Convert date | dates | Converts date measurement units. |
| Modify date | dates | Adds or subtracts time unit amount. |
| Calculate absolute value | math | Calculates the absolute value for all the numeric values in this column. |
| Modulo | math | Calculates the reminder of a division operation. |
| Negate | math | Negates a column number. |
| Add, multiply, subtract, or divide | math | Performs an operation/calculation on this column with another one or with a fixed value: Add/sum (+), multiply (x), subtract (-), or divide (/). |
| Remove fractional part | numbers | Rounds towards zero. (3.74 -> 3) and (-3.74 -> -3). |
| Remove negative values | numbers | Replaces negative integer or decimal values with empty values. |
| Round value using ceil mode | numbers | Rounds value to the largest integer (3.14 -> 4 if Precision is set to 0, and 3.14 -> 3.2 if Precision is set to 1). |
| Round value using floor mode | numbers | Rounds value to the smallest integer (3.74 -> 3 if Precision is set to 0, and 3.74 -> 3.7 if Precision is set to 1). |
| Round value using half up mode | numbers | Rounds value to the closest integer (3.14 -> 3 and 3.74 -> 4 for a Precision set to 0). |
| Round value using down mode | numbers | Rounds towards zero. (3.74 -> 3 and -3.74 -> -3 for a Precision set to 0). |
| Format phone number | phones | Formats a phone number to the selected format. |
| Change to lower case | strings | Converts all of the cell text in this column to lower case. |
| Change to title case | strings | Converts the text content from this column to title case (i.e. "data prep" -> "Data Prep"). |
| Change to upper case | strings | Converts all of the cell text in this column to UPPER case (capitalize). |
| Remove part of the text | strings | Removes specified text from cells in this column. |
| Remove consecutive characters | strings | Removes repeated characters (i.e. spaces). |
| Search and replace | strings | Replace cells or parts of cells which contain a specific value. |
| Remove trailing and leading characters | strings | Removes trailing and leading spaces (i.e. trim). |
| Replace the cells that match | strings | Replaces the cells that have a specific value. |
| Convert character width | strings advanced | Converts the character width to half or full width, or normalize strings. |
| Add extra characters | strings advanced | Adds extra characters (padding) on the left or on the right of the original value to match an expected size. |
| Remove non alpha numeric characters | strings advanced | For example €10.5k will become 105k. |
| Remove non numeric characters | strings advanced | For example €10.5k will become 10.5. |
| Simplify text (remove case, accent, etc.) | strings advanced | Simplifies the content of this column. For example: François becomes francois. |
| Apply survivorship rule | survivorship | Decides what value to use to build the master record. |