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 |
|---|---|
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 |
Conditional column | Returns values based on conditions such as if-then-else or case statements. See Apply Conditional Transformations. |
Convert patterns | Finds one or more patterns or text literals and replaces them with specified pattern values. |
Count matches | Counts the number of matches [countpattern] |
Count matches between delimiters | Counts the number of matches [countpattern]. Variant: Between delimiters. |
Remove duplicate rows | Removes duplicate rows where values in every column are the same. See Deduplicate Data. |
New formula | Creates a new column with the result of a formula |
Delete columns | Delete one or more columns. See Remove Data. |
Extract text between delimiters | Extracts text found between two patterns. See Extract Values. |
Extract text or pattern | 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 key-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 the last n characters. See Extract Values. |
Extract mismatched values | Extracts a list into an Array [extractlist]. Variant: The data type to match against. See Extract Values. |
Extract numbers from text | Extracts a list into an Array [extractlist]. Variant: Extract numbers from a text. See Extract Values. |
Extract HTTP query strings | Extracts 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 Filter Data. |
Filter rows using custom formula | Filter rows that satisfy a condition. Variant: Filter rows that satisfy an arbitrary formula. 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 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 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 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 Filter Data. |
Filter rows at regular interval | Filter rows by their position. Variant: . Variant: The size of the interval to filter rows at. 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 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: Specify a prefix to be added at the beginning of each selected column name. |
Convert text to Propercase | Format text in columns. Variant: Convert text in column to ProperCase. 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 the new name for each column. See Rename Columns. |
Rename columns with a prefix | Renames one or more columns [rename]. Variant: Specify the new name for each column. See Rename Columns. |
Rename columns with row(s | Renames one or more columns [rename]. Variant: Specify the new name for each column. See Rename Columns. |
Rename columns with a suffix | Renames one or more columns [rename]. Variant: Specify the 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. NOTE: This transformation is not available in Dataprep by Trifacta. |
Split column on delimiter | Split by delimiter. Variant: Text 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: Specify 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 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 NOTE: This transformation is only available in Designer Cloud Enterprise Edition. It requires additional configuration. |
Convert text to UPPERCASE | Format text in columns. Variant: Convert text in column to UPPERCASE. 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 unnested 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] |
This page has no comments.