Transformation Reference

Contents:

Expand all Collapse all

Contents:

This section contains reference information on the transformations available in the application.

Tip: Use the values in the Title column as search strings in the Search panel to begin specifying these transformations.

Title	Description
Add comment	Adds a comment to your recipe [comment]. See Add Comments to Your Recipe.
Add prefix to text	Format text in columns. Variant: Specify a prefix to be added at the beginning of each selected column name.
Add suffix to text	Format text in columns. Variant: Specify a suffix to be added to the end of each selected column name.
Change column type	Changes the data type of a column [settype].
Change date format	Change format for Datetime columns
Conditional column	Returns values based on conditions such as if-then-else or case statements. See Apply Conditional Transformations.
Convert key/value pairs into Objects	Extracts key-value pairs into an Object [extractkv]
Convert list into Array	Extracts a list into an Array [extractlist].
Convert patterns	Counts the number of matches [countpattern]
Convert text to lowercase	Format text in columns. Variant: Convert text in column to lowercase. See Standardize Non-Numeric Values.
Convert text to Propercase	Format text in columns. Variant: Convert text in column to ProperCase. See Standardize Non-Numeric Values.
Convert text to UPPERCASE	Format text in columns. Variant: Convert text in column to UPPERCASE. See Standardize Non-Numeric Values.
Convert values to columns	Creates a new column for each unique value in a column [valuestocols]
Count matches	Counts the number of matches [countpattern]
Count matches between delimiters	Counts the number of matches [countpattern]. Variant: Specify the patterns that precede and/or follow the value you want to count.
Delete columns	Delete one or more columns. See Remove Data.
Edit column with formula	Sets the values of one or more columns to the result of a formula [set].
Expand Arrays into rows	Converts each element in an Array into a new row
Extract characters between positions	Extracts text according to its position. Variant: Extract the last n characters.
Extract HTTP query strings	Extracts a list into an Array [extractlist]. Variant: Extract fields from an URL query string.
Extract mismatched values	Extracts a list into an Array [extractlist]. Variant: The data type to match against
Extract numbers from text	Extracts a list into an Array [extractlist]. Variant: Extract numbers from a text.
Extract text between delimiters	Extracts text found between two patterns.
Extract text or pattern	Extracts text found between two patterns. Variant: Custom text or pattern.
Extract the first n characters	Extracts text according to its position. Variant: Extract the first n characters.
Extract the last n characters	Extracts key-value pairs into an Object [extractkv]. Variant: Extract the last n characters.
Filter rows at regular interval	Filter rows by their position. Variant: . Variant: The size of the interval to filter rows at. See Remove Data.
Filter rows from top	Filter rows by their position. Variant: Filter rows from the top. See Remove Data.
Filter rows in range	Filter rows by their position. Variant: Filter rows within a range.
Filter rows using custom formula	Filter rows that satisfy a condition. Variant: Filter rows that satisfy an arbitrary formula. See Remove Data.
Filter rows when value contains	Filter rows that satisfy a condition. Variant: Filter rows that contain a specified value or pattern. See Remove Data.
Filter rows when value ends with	Filter rows that satisfy a condition. Variant: Filter rows that ends with a specified value or pattern. See Remove Data.
Filter rows when value is exactly	Filter rows that satisfy a condition. Variant: Filter rows that match exactly a specified value. See Remove Data.
Filter rows when value is greater than	Filter rows that satisfy a condition. Variant: Filter rows with values greater than (or equal to) a specified value. See Remove Data.
Filter rows when value is less than	Filter rows that satisfy a condition. Variant: Filter rows with values less than (or equal to) a specified value.
Filter rows when value is mismatched	Filter rows that satisfy a condition. Variant: Filter rows with mismatched values.
Filter rows when value is missing	Filter rows that satisfy a condition. Variant: Filter rows with missing values.
Filter rows when value is one of	Filter rows that satisfy a condition. Variant: Filter rows that match any of the specified values.
Filter rows when value starts with	Filter rows that satisfy a condition. Variant: Filter rows that starts with a specified value or pattern.
Invoke external function	Creates a new column with the result of an external function NOTE: This transformation is only available in Designer Cloud Enterprise Edition. It requires additional configuration.
Join datasets	Adds additional columns from other data sources [join]. See Join Page.
Merge columns	Concatenates the values from two or more columns into a new column [merge]
Move columns	Moves one or more columns before or after another column [move]
Nest columns into objects	Converts columns into an Object or Array [nest]
New formula	Creates a new column with the result of a formula
Pad text with leading characters	Format text in columns. Variant: Add the necessary number of characters to each value to make them of the same length.
Pivot table	Creates a new column for each unique value in a column [pivot]
Remove duplicate rows	Removes duplicate rows where values in every column are the same. See Remove Data.
Remove symbols from text	Format text in columns. Variant: Remove all non-alphanumerical characters from the text.
Remove whitespace from text	Format text in columns. Variant: Remove all whitespace found in the text.
Rename columns	Renames one or more columns [rename]. Variant: Specify the new name for each column.
Rename columns based on a pattern	Renames one or more columns [rename]. Variant: Specify a text or pattern to be replaced in each selected column name.
Rename columns with a prefix	Renames one or more columns [rename]. Variant: Specify a prefix to be added at the beginning of each selected column name.
Rename columns with a row	Renames one or more columns [rename]. Variant: Specify a row containg the names to be used as header.
Rename columns with a suffix	Renames one or more columns [rename]. Variant: Specify a suffix to be added at the end of each selected column name.
Replace between delimiters	Replace text between delimiters. Variant: Replace text between delimiters.
Replace between positions	Replace text between delimiters. Variant: Replaces text based on position.
Replace mismatched values	Replace mismatched values.
Replace missing values	Replace missing values.
Replace text or pattern	Replace text matching a pattern.
Sort columns	Sorts the rows based on the values in one or more columns. NOTE: This transformation is not available in Dataprep by Trifacta.
Split column at regular interval	Split by character position. Variant: At regular interval.
Split column between positions	Split by character position. Variant: Between two positions.
Split column between two delimiters	Split by delimiter. Variant: Between two delimiters.
Split column by positions	Split by character position. Variant: By positions.
Split column on delimiter	Split by delimiter. Variant: Text or pattern.
Split column on multiple delimiters	Split by delimiter. Variant: By multiple delimiters.
Split raw data into rows	Splits raw data into rows [splitrows]
Trim quotes	Format text in columns. Variant: Remove quotes found at the beginning and end of the text.
Trim whitespace	Format text in columns. Variant: Remove all whitespaces found at the beginning and end of the text. See Standardize Non-Numeric Values.
Union datasets	Adds additional rows from other data source [union]. See Union Page.
Unnest Object elements	Extracts elements from an Object or Array into columns
Unpivot columns	Turns columns into rows. Produces a key column with
Window	Performs row-based calculations across multiple ordered rows [window]

Send Feedback

Page tree

Transformation Reference

Add comment

Add prefix to text

Add suffix to text

Change column type

Change date format

Conditional column

Convert key/value pairs into Objects

Convert list into Array

Convert patterns

Convert text to lowercase

Convert text to Propercase

Convert text to UPPERCASE

Convert values to columns

Count matches

Count matches between delimiters

Delete columns

Edit column with formula

Expand Arrays into rows

Extract characters between positions

Extract HTTP query strings

Extract mismatched values

Extract numbers from text

Extract text between delimiters

Extract text or pattern

Extract the first n characters

Extract the last n characters

Filter rows at regular interval

Filter rows from top

Filter rows in range

Filter rows using custom formula

Filter rows when value contains

Filter rows when value ends with

Filter rows when value is exactly

Filter rows when value is greater than

Filter rows when value is less than

Filter rows when value is mismatched

Filter rows when value is missing

Filter rows when value is one of

Filter rows when value starts with

Invoke external function

Join datasets

Merge columns

Move columns

Nest columns into objects

New formula

Pad text with leading characters

Pivot table

Remove duplicate rows

Remove symbols from text

Remove whitespace from text

Rename columns

Rename columns based on a pattern

Rename columns with a prefix

Rename columns with a row

Rename columns with a suffix

Replace between delimiters

Replace between positions

Replace mismatched values

Replace missing values

Replace text or pattern

Sort columns

Split column at regular interval

Split column between positions

Split column between two delimiters

Split column by positions

Split column on delimiter

Split column on multiple delimiters

Split raw data into rows

Trim quotes

Trim whitespace

Union datasets

Unnest Object elements

Unpivot columns

Window