Contents:
Contents:
The following changes have been applied to Wrangle in this release of Designer Cloud.
Release 8.5
Support for numeric separators in NUMFORMAT function
Beginning in Release 8.5, the NUMFORMAT function supports the following configurable separators for localizing numeric values:
| Option Name | Description |
|---|---|
| Decimal Separator | The string used to separate the integer part of a Decimal value from its fractional part. |
| Grouping Separator | The string used to separate a group of digits. |
For more information, see NUMFORMAT Function.
New functions
| Function Name | Description |
|---|---|
| NUMVALUE Function | Converts a string formatted as a number into an Integer or Decimal value by parsing out the specified decimal and group separators. A string or a function returning formatted numbers of String type or a column containing formatted numbers of string type can be inputs. |
Release 8.4
New functions
Documentation for the following functions is now available.
| Function Name | Description |
|---|---|
| FINDNTH Function | Returns the position of the nth occurrence of a letter or pattern in the input string where a specified matching string is located in the provided column. You can search either from left or right. |
| PARSESTRING Function | Evaluates an input against the String datatype. If the input matches, the function outputs a String value. Input can be a literal, a column of values, or a function returning values. Values can be of any data type. |
| PARSEARRAY Function | Evaluates a String input against the Array datatype. If the input matches, the function outputs an Array value. Input can be a literal, a column of values, or a function returning String values. |
| PARSEOBJECT Function | Evaluates a String input against the Object datatype. If the input matches, the function outputs an Object value. Input can be a literal, a column of values, or a function returning String values. |
Release 8.3
None.
Release 8.2
None.
Release 7.10
New functions
| Function Name | Description |
|---|---|
| EOMONTH Function | Returns the serial date number for the last day of the month before or after a specified number of months from a starting date. |
Release 7.9
Transform Builder now supports All columns option
Beginning in Release 7.9, select All columns option has been added in the Transform Builder.
| Option Name | Description |
|---|---|
| All | Selects all columns in the dataset |
Example:
| Transformation Name | Rename columns |
|---|---|
| Parameter: Option | Add suffix |
| Parameter: Columns | All |
| Parameter: Suffix | _new |
The following is the list of the transformations that accept the All option for selecting columns:
Date format
Delete columns
Move columns
Rename column
Replace
Replace text or patterns
Replace cells
Replace text between delimiters
Replace by position
Replace mismatched values
Replace missing values
Edit with formula
Change column type
Text format
Unpivot columns
For more information, see Transform Builder.
Release 7.8
Rename transform now supports Upper / Lower and Left / Right options
Beginning in Release 7.8, the Rename transform supports the following new options:
| Option Name | Description |
|---|---|
| Convert to lowercase | Converts existing column names to lowercase |
| Convert to UPPERCASE | Converts existing column names to uppercase |
| Keep from beginning (left) | Specifies the number of characters to keep from the beginning of column names |
| Keep from end (right) | Specifies the number of characters to keep from the end of column names |
For more information on rename columns, see Rename Columns.
Release 7.5
New Functions
Approximation statistical functions:
Tip: Approximation functions are suitable for larger datasets. As the number of rows increases, accuracy and calculation performance improves for these functions.
| Function Name | Description |
|---|---|
| APPROXIMATEMEDIAN Function | Computes the approximate median from all row values in a column or group. Input column can be of Integer or Decimal. |
| APPROXIMATEPERCENTILE Function | Computes an approximation for a specified percentile across all row values in a column or group. Input column can be of Integer or Decimal. |
| APPROXIMATEQUARTILE Function | Computes an approximation for a specified quartile across all row values in a column or group. Input column can be of Integer or Decimal. |
base64 encoding functions:
| Function Name | Description |
|---|---|
| BASE64ENCODE Function |
Converts an input value to base64 encoding with optional padding with an equals sign ( |
| BASE64DECODE Function | Converts an input base64 value to text. Output type is String. |
Release 7.4
New Functions
| Function Name | Description |
|---|---|
| WEEKDAYNAME Function | Derives the full name from a Datetime value of the corresponding weekday as a String. Source value can be a reference to a column containing Datetime values or a literal. |
This page has no comments.