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 | 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 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 Panel. |
| 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]. |
| 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]. See Pivot Data. |
| 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. |
| 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 selected from your current dataset. See Select. |
| 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. See Sort Order. |
| 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. NOTE: This transformation requires additional configuration. |
| 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. 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 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. 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.