Transformation Reference

scaleminmax

Scale to min max

Scale a column to a specific min max range. See Prepare Data for Machine Processing.

onehotencode

One hot encode

Create a column for each unique value indicating its presence or absence. See Prepare Data for Machine Processing.

scalestandardize

Scale to mean

Scale a column to zero mean and unit variance. See Prepare Data for Machine Processing

bincolumn

Bin column

Bin values into ranges of equal or custom size. See Prepare Data for Machine Processing

changetype

Change column type

Changes the data type of a column [settype]. See Change Column Data Type

comment

Comment

Adds a comment to your recipe [comment]. See Change Column Data Type

conditions

Conditional column

Returns values based on conditions such as if-then-else or case statements. See Apply Conditional Transformations.

convertpattern

Convert patterns

Finds one or more patterns or text literals and replaces them with specified pattern values. See Standardize Using Patterns.

countmatches

Count matches

Counts the number of matches [countpattern]. See Compute Counts .

countmatchesbetween

Count matches between delimiters

Counts the number of matches [countpattern]. See Compute Counts

deduplicate

Remove duplicate rows

Removes duplicate rows where values in every column are the same. See Deduplicate Data.

derive

New formula

Creates a new column with the result of a formula.

drop

Delete columns

Delete one or more columns. See Remove Data.

extractbetweendelimiters

Extract between delimiters

Extracts text found between two patterns. See Extract Values

extractcustom

Extract text or pattern

Extracts text found between two patterns. Variant: Custom text or pattern . See Extract Values

extractfirstcharacters

Extract first

Extracts text according to its position. Variant: Extract the first n characters. See Extract Values

extractkv

Convert key/value to Object

Extracts key-value pairs into an Object [extractkv]. See Extract Values

extractlastcharacters

Extract last

Extracts key-value pairs into an Object [extractkv]. Variant: Extract the last n characters. See Extract Values

extractlist

Extract matches to Array

Extracts a list into an Array [extractlist]. See Extract Values

extractrangeofcharacters

Extract between positions

Extracts text according to its position. Variant: Extract the last n characters. See Extract Values

extractmismatched

Extract mismatched

Extracts a list into an Array [extractlist]. Variant: The data type to match against. See Extract Values

extractnumbers

Extract numbers

Extracts a list into an Array [extractlist]. Variant: Extract numbers from a text. See Extract Values

extractquerystrings

Extract query strings

Extracts a list into an Array [extractlist]. Variant: Extract fields from an URL query string. See Extract Values

filtercontains

Filter contains

Filter rows that satisfy a condition. Variant: Filter rows that contain a specified value or pattern. See Filter Data.

filtercustom

Filter custom formula

Filter rows that satisfy a condition. Variant: Filter rows that satisfy an arbitrary formula. See Filter Data.

filterendswith

Filter ends with

Filter rows that satisfy a condition. Variant: Filter rows that ends with a specified value or pattern. See Filter Data

filterexactly

Filter exact

Filter rows that satisfy a condition. Variant: Filter rows that match exactly a specified value. See Filter Data.

filternot

Filter not equals

Filters rows that do not satisfy a condition. See Filter Data

filterfromtop

Filter from top

Filter rows by their position. Variant: Filter rows from the top. See Filter Data.

filtergreaterthan

Filter greater than

Filter rows that satisfy a condition. Variant: Filter rows with values greater than (or equal to) a specified value. See Filter Data.

filterinterval

Filter at interval

Filter rows by their position. Variant: Variant: The size of the interval to filter rows at. See Filter Data.

filterlessthan

Filter less than

Filter rows that satisfy a condition. Variant: Filter rows with values less than (or equal to) a specified value. See Filter Data.

filtermissing

Filter missing

Filter rows that satisfy a condition. Variant: Filter rows with missing values. See Remove Data.

filtermismatched

Filter mismatched

Filter rows that satisfy a condition. Variant: Filter rows with mismatched values. See Filter Data

filteroneof

Filter in

Filter rows that satisfy a condition. Variant: Filter rows that match any of the specified values. See Filter Data.

filterrange

Filter range

Filter rows by their position. Variant: Filter rows within a range. See Filter Data.

filterstartswith

Filter starts with

Filter rows that satisfy a condition. Variant: Filter rows that starts with a specified value or pattern. See Filter Data

flatten

Expand Array to rows

Converts each element in an Array into a new row. See Working with Arrays.

groupby

Group by

Group data and perform aggregated calculations on it. See Create Aggregations.

join

Join datasets

Adds additional columns from other data sources [join]. See Join Window

locktype

Lock type

Lock column to current type.

lowercase

Lowercase text

Format text in columns. Variant: Convert text in column to lowercase. See Modify String Values

leftpad

Pad with leading

Format text in columns. Variant: Add the necessary number of characters to each value to make them of the same length. See Modify String Values

merge

Merge columns

Concatenates the values from two or more columns into a new column [merge]. See Add Two Columns.

move

Move columns

Moves one or more columns before or after another column [move]. See Move Columns

nest

Nest columns

Converts columns into an Object or Array [nest]. See Working with Arrays

pivot

Pivot

Creates a new column for each unique value in a column [pivot].

prefix

Prefix text

Format text in columns. Variant: Specify a prefix to be added at the beginning of each selected column name. See Modify String Values.

propercase

Propercase text

Format text in columns. Variant: Convert text in column to ProperCase. See Modify String Values

removesymbols

Remove symbols in text

Format text in columns. Variant: Remove all non-alphanumerical characters from the text. See Remove Data.

removewhitespace

Remove whitespace in text

Format text in columns. Variant: Remove all whitespace found in the text. See Remove Data.

removeaccents

Remove accents in text

Remove accent marks from text. See Modify String Values.

rename

Rename columns

Renames one or more columns [rename]. See Rename Columns.

renamepattern

Rename with pattern

Renames one or more columns [rename]. See Rename Columns

renameprefix

Rename with prefix

Renames one or more columns [rename]. See Rename Columns

renameheader

Rename with row(s

Renames one or more columns [rename]. See Rename Columns

renamesuffix

Rename with suffix

Renames one or more columns [rename]. See Rename Columns

renameupper

Rename to UPPERCASE

Renames one or more columns [rename]. See Rename Columns

renamelower

Rename to lowercase

Renames one or more columns [rename]. See Rename Columns

renamekeepleft

Rename from beginning

Renames one or more columns [rename]. See Rename Columns

renamekeepright

Rename from end

Renames one or more columns [rename]. See Rename Columns

renamesanitize

Rename by removing special characters

Renames one or more columns [rename]. See Rename Columns.

replacecell

Replace cells

Renames one or more columns [rename]. See Rename Columns.

replacepattern

Replace text or pattern

Replace text matching a pattern. See Replace Cell Values

replacebetweenpatterns

Replace between delimiters

Replace text between delimiters. Variant: Replace text between delimiters. See Replace Cell Values.

replacebetweenpositions

Replace between positions

Replace text between delimiters. Variant: Replaces text based on position. See Replace Cell Values

replacemismatched

Replace mismatched

Replace mismatched values. See Replace Cell Values

replacemissing

Replace missing

Replace missing values. See Replace Cell Values.

select

Select

Create a new table of columns from your current dataset.

set

Edit with formula

Sets the values of one or more columns to the result of a formula [set].

sort

Sort rows

Sorts the rows based on the values in one or more columns.

splitondelimiter

Split on text or pattern

Split by delimiter. Variant: Text or pattern. See Split Column

splitbetweendelimiters

Split between delimiters

Split by delimiter. Variant: Between two delimiters. See Split Column.

splitmultipledelimiters

Split with multiple delimiters

Split by delimiter. Variant: By multiple delimiters. See Split Column.

splitpositions

Split at positions

Split by character position. Variant: By positions. See Split Column

splitevery

Split at interval

Split by character position. Variant: At regular interval. See Split Column.

splitbetweenpositions

Split between positions

Split by character position. Variant: Between two positions. See Split Column.

splitrows

Split into rows

Splits raw data into rows [splitrows]. See Split Column.

suffix

Suffix text

Format text in columns. Variant: Specify a suffix to be added to the end of each selected column name. See Modify String Values.

trimwhitespace

Trim whitespace

Format text in columns. Variant: Remove all whitespaces found at the beginning and end of the text. See Modify String Values.

trimquotes

Trim quotes

Format text in columns. Variant: Remove quotes found at the beginning and end of the text. See Modify String Values.

udf

Invoke external function

Creates a new column with the result of an external function.

uppercase

Uppercase text

Format text in columns. Variant: Convert text in column to UPPERCASE. See Modify String Values

dateformat

Date format

Change format for Datetime columns. See Format Dates.

union

Union datasets

Adds additional rows from other data source [union]. See Union Page.

standardize

Standardize column

Single-column standardization for standardizing column values. See Standardize Page

columnbyexample

Create column from examples

Create a new column by providing example values. See Create Column by Example

unlocktype

Unlock type

Unlock column type.

unnest

Unnest elements

Extracts elements from an Object or Array into columns. See Working with Arrays

unpivot

Unpivot

Turns columns into rows. Produces a key column with unnested values.

valuestocols

Convert values to columns

Creates a new column for each unique value in a column [valuestocols].

window

Window

Performs row-based calculations across multiple ordered rows [window]. See Window Functions.

sourcerownumber

sourcerownumber

Generate a new column containing the row number for each row from the source, if available. See Source Metadata References.

filepath

filepath

Generate a new column containing the path to the source file, if available. See Source Metadata References