...
| 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
| ||||||
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.
| ||||||
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] |
