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. |