List of functions on columns - 7.0

Talend Data Stewardship User Guide

Version
7.0
Language
English (United States)
Product
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Data Stewardship
Content
Administration and Monitoring > Managing users
Data Governance > Assigning tasks
Data Governance > Managing campaigns
Data Governance > Managing data models
Data Quality and Preparation > Handling tasks
Installation and Upgrade
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

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

Convert distance

conversions

Convert distance measurement units

Convert duration

conversions

Convert time duration measurement units

Convert temperature

conversions

Converts temperature measurement units

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(/)

Concatenate with

columns

Merges the content of this column with another one, and displays the content in a new column

Remove fractional part

numbers

Round towards zero. (3.74 -> 3) and (-3.74 -> -3)

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

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 all non alpha numeric characters

strings advanced

For example €10.5k will become 105

Remove all 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