Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

...

Tip

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

TitleDescription

Change column type

Changes the data type of a column [settype].

Add comment

Adds a comment to your recipe [comment]. See Add Comments to Your Recipe.

Change column type

Changes the data type of a column [settype]

Conditional column

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

Convert patterns

Change format of specified values to match new patterns
Finds one or more patterns or text literals and replaces them with specified pattern values.

Count matches

Counts the number of matches [countpattern]. Variant: Specify the pattern that matches the value you want to count.

Count matches between delimiters

Counts the number of matches [countpattern]. Variant: Specify the patterns that precede and/or follow the value you want to countBetween delimiters.

Remove duplicate rows

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

New formula

Creates a new column with the result of a formula

Delete columns

Delete one or more columns. See See Remove Data.

Extract text between delimiters

Extracts text found between two patterns. See Extract Values.

Extract text or pattern

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

Extract the first n characters

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

Convert key/value pairs into Objects

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

Extract the last n characters

Extracts text according to its positionkey-value pairs into an Object [extractkv]. Variant: Extract the last n characters. See Extract Values.

Convert list into Array

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

Extract characters between positions

Extracts text according to its position. Variant: Extract text between two positionsthe last n characters. See Extract Values.

Extract mismatched values

Extract patterns
Extracts a list into an Array [extractlist]. Variant: Extract values that do not match a given The data type to match against. See Extract Values.

Extract numbers from text

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

Extract HTTP query strings

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

Filter rows when value contains

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

Filter rows using custom formula

Filter rows that satisfy a condition. Variant: Filter rows that satisfy an arbitrary formula. See Remove See Filter 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 See Filter Data.

Filter rows when value is exactly

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

Filter rows when value

. See Remove

is not

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

Filter rows from top

Filter rows by their position. Variant: Filter rows from the top. See Remove See Filter 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 See Filter Data.

Filter rows at regular interval

Filter rows by their position. Variant: . Variant: Filter The size of the interval to filter rows at a regular interval. See Remove . See Filter 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. See Filter Data.

Filter rows when value is missing

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

Filter rows when value is mismatched

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

Filter rows when value is one of

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

Filter rows in range

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

Filter rows when value starts with

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

Expand Arrays into rows

Converts each element in an Array into a new row

Group by

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

Join datasets

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

Convert text to lowercase

Format text in columns. Variant: Convert text in column to lowercase. See See Standardize Non-Numeric Values.

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.

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]

Pivot table

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

Add prefix to text

Format text in columns. Variant: Insert a custom text Specify a prefix to be added at the end beginning of each valueselected column name.

Convert text to Propercase

Format text in columns. Variant: Convert text in column to ProperCase. See  See Standardize Non-Numeric Values.

Remove symbols from text

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

Remove whitespace from text

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

Rename columns

Renames one or more columns [rename]. Variant: Specify the new name for each column. See Rename Columns.

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 namethe new name for each column. See Rename Columns.

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 namethe new name for each column. See Rename Columns.

Rename columns with

a

row(s

Renames one or more columns [rename]. Variant: Specify a row containing the names to be used as headerthe new name for each column. See Rename Columns.

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 namethe new name for each column. See Rename Columns.

Replace text or pattern

Replace text matching a pattern. See Replace Values.

Replace between delimiters

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

Replace between positions

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

Replace mismatched values

Replace mismatched values. See Replace Values.

Replace missing values

Replace missing values. See Replace Values.

Edit column with formula

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

Sort columns

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

Info

NOTE:  This transformation is not available in  

D s product
productgdp
.

Split column on delimiter

Split by delimiter. Variant: By delimiterText or pattern.

Split column between two delimiters

Split by delimiter. Variant: Between two delimiters.

Split column on multiple delimiters

Split by delimiter. Variant: By multiple delimiters.

Split column by positions

Split by character position. Variant: By positions.

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 raw data into rows

Splits raw data into rows [splitrows]

Add suffix to text

Format text in columns. Variant: Insert a custom text at the beginning of each valueSpecify a suffix to be added to the end of each selected column name. See Standardize Non-Numeric Values.

Trim whitespace

Format text in columns. Variant: Remove all whitespaces found at the beginning and end of the text. See See Standardize Non-Numeric Values.

Trim quotes

Format text in columns. Variant: Remove quotes found at the beginning and end of the text. See Standardize Non-Numeric Values.

Invoke external function

Creates a new column with the result of an external function

true
Info

NOTE:  This transformation is only available in  

D s product
productee
r
. It requires additional configuration.

Convert text to UPPERCASE

Format text in columns. Variant: Convert text in column to UPPERCASE. See  See Standardize Non-Numeric Values .

Change date format

Change format for Datetime columns. See Format Dates.

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 the name of the original column and a value column with the original valueunnested values.

Convert values to columns

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

Window

Performs row-based calculations across multiple ordered rows [window]