Skip to main content

List of functions on columns

This table defines all the functions you can perform on columns in Talend 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

Convert distance measurement units

Convert duration

conversions

Convert 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

Convert 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 halfup 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

Convert 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 105

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 (i.e. François -> 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!