Contents:
Contents:
The following changes have been applied to Wrangle in this release of Designer Cloud.
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.