Contents:
This section contains reference information on the transformations available in Designer Cloud Enterprise Edition.
Tip: Use the values in the Title column as search strings in the Search panel to begin specifying these transformations.
| Name | Title | Description |
|---|---|---|
| changetype | Change column type | Changes the data type of a column [settype]. See Change Column Data Type. |
| comment | Add comment | Adds a comment to your recipe [comment]. See Add Comments to Your Recipe. |
| 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 text 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 the first n characters | Extracts text according to its position. Variant: Extract the first n characters. See Extract Values. |
| extractkv | Convert key/value pairs into Objects | Extracts key-value pairs into an Object [extractkv]. See Extract Values. |
| extractlastcharacters | Extract the last n characters | Extracts key-value pairs into an Object [extractkv]. Variant: Extract the last n characters. See Extract Values. |
| extractlist | Convert list into Array | Extracts a list into an Array [extractlist]. See Extract Values. |
| extractrangeofcharacters | Extract characters between positions | Extracts text according to its position. Variant: Extract the last n characters. See Extract Values. |
| extractmismatched | Extract mismatched values | Extracts a list into an Array [extractlist]. Variant: The data type to match against. See Extract Values. |
| extractnumbers | Extract numbers from text | Extracts a list into an Array [extractlist]. Variant: Extract numbers from a text. See Extract Values. |
| extractquerystrings | Extract HTTP query strings | Extracts a list into an Array [extractlist]. Variant: Extract fields from an URL query string. See Extract Values. |
| filtercontains | Filter rows when value contains | Filter rows that satisfy a condition. Variant: Filter rows that contain a specified value or pattern. See Filter Data. |
| filtercustom | Filter rows using custom formula | Filter rows that satisfy a condition. Variant: Filter rows that satisfy an arbitrary formula. See Filter Data. |
| filterendswith | 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. |
| filterexactly | Filter rows when value is exactly | Filter rows that satisfy a condition. Variant: Filter rows that match exactly a specified value. See Filter Data. |
| filternot | Filter rows when value is not | Filters rows that do not satisfy a condition. See Filter Data. |
| filterfromtop | Filter rows from top | Filter rows by their position. Variant: Filter rows from the top. See Filter Data. |
| filtergreaterthan | 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. |
| filterinterval | Filter rows at regular interval | Filter rows by their position. Variant: . Variant: The size of the interval to filter rows at. See Filter Data. |
| filterlessthan | 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. |
| filtermissing | Filter rows when value is missing | Filter rows that satisfy a condition. Variant: Filter rows with missing values. See Remove Data. |
| filtermismatched | Filter rows when value is mismatched | Filter rows that satisfy a condition. Variant: Filter rows with mismatched values. See Filter Data. |
| filteroneof | 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. |
| filterrange | Filter rows in range | Filter rows by their position. Variant: Filter rows within a range. See Filter Data. |
| filterstartswith | 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. |
| flatten | Expand Arrays into 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 Panel. |
| lowercase | Convert text to lowercase | Format text in columns. Variant: Convert text in column to lowercase. See Modify String Values. |
| leftpad | 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. 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]. |
| nest | Nest columns into objects | Converts columns into an Object or Array [nest]. See Working with Arrays. |
| pivot | Pivot table | Creates a new column for each unique value in a column [pivot]. See Pivot Data. |
| prefix | Add prefix to 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 | Convert text to Propercase | Format text in columns. Variant: Convert text in column to ProperCase. See Modify String Values. |
| removesymbols | Remove symbols from text | Format text in columns. Variant: Remove all non-alphanumerical characters from the text. See Remove Data. |
| removewhitespace | Remove whitespace from text | Format text in columns. Variant: Remove all whitespace found in the text. See Remove Data. |
| removeaccents | Remove accents from text | Remove accent marks from text. See Modify String Values. |
| rename | Rename columns | Renames one or more columns [rename]. See Rename Columns. |
| renamepattern | Rename columns based on a pattern | Renames one or more columns [rename]. See Rename Columns . |
| renameprefix | Rename columns with a prefix | Renames one or more columns [rename]. See Rename Columns . |
| renameheader | Rename columns with row(s | Renames one or more columns [rename]. See Rename Columns . |
| renamesuffix | Rename columns with a suffix | Renames one or more columns [rename]. See Rename Columns . |
| renamesanitize | Rename columns by removing special characters | Renames one or more columns [rename]. See Sanitize Column Names. |
| 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 values | Replace mismatched values. See Replace Cell Values. |
| replacemissing | Replace missing values | Replace missing values. See Replace Cell Values. |
| set | Edit column 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. See Sort Order. |
| splitondelimiter | Split column on delimiter | Split by delimiter. Variant: Text or pattern. See Split Column. |
| splitbetweendelimiters | Split column between two delimiters | Split by delimiter. Variant: Between two delimiters. See Split Column. |
| splitmultipledelimiters | Split column on multiple delimiters | Split by delimiter. Variant: By multiple delimiters. See Split Column. |
| splitpositions | Split column by positions | Split by character position. Variant: By positions. See Split Column. |
| splitevery | Split column at regular interval | Split by character position. Variant: At regular interval. See Split Column. |
| splitbetweenpositions | Split column between positions | Split by character position. Variant: Between two positions. See Split Column. |
| splitrows | Split raw data into rows | Splits raw data into rows [splitrows]. See Split Column. |
| suffix | Add suffix to 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. NOTE: This transformation requires additional configuration. |
| uppercase | Convert text to UPPERCASE | Format text in columns. Variant: Convert text in column to UPPERCASE. See Modify String Values. |
| dateformat | Change 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. NOTE: This Advanced Feature is available in Designer Cloud Enterprise Edition under a separate, additional license. If it is not available under your current license, do not enable it for use. Please feel free to contact your representative. |
| columnbyexample | Create column from examples | Create a new column by providing example values. See Create Column by Example. |
| unnest | Unnest Object elements | Extracts elements from an Object or Array into columns. See Working with Arrays. |
| unpivot | Unpivot columns | Turns columns into rows. Produces a key column with unnested values. See Pivot Data. |
| valuestocols | Convert values to columns | Creates a new column for each unique value in a column [valuestocols]. See Pivot Data. |
| window | Window | Performs row-based calculations across multiple ordered rows [window]. See Window Functions. |
| sourcerownumber | Metadata $sourcerownumber | Generate a new column containing the row number for each row from the source, if available. See Source Metadata References. |
| filepath | Metadata $filepath | Generate a new column containing the path to the source file, if available. See Source Metadata References . |
This page has no comments.