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.