Skip to main content

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.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!