...
The following changes have been applied to
| D s lang |
|---|
| D s product | ||
|---|---|---|
|
Release 8.10
Split by position no longer requires sorted list of positions
Beginning in this release, when you create a Split by position transformation, the numeric values indicating the positions do not need to be listed in sorted numeric order.
| Tip |
|---|
Tip: You can now do faster iteration since you can add new positions as needed when previewing the transformation. |
For more information, see Split Column.
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 |
|
Release 8.4
New functions
Documentation for the following functions is now available.
| Function Name | Description | ||||||
|---|---|---|---|---|---|---|---|
| FINDNTH Function |
| ||||||
| PARSESTRING Function |
| ||||||
| PARSEARRAY Function |
| ||||||
| PARSEOBJECT Function |
|
Release 8.3
None.
Release 8.2
None.
Release 7.10
New functions
| Function Name | Description | ||||||
|---|---|---|---|---|---|---|---|
| EOMONTH Function |
|
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:
| D trans | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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:
...
| Function Name | Description | ||||||
|---|---|---|---|---|---|---|---|
| BASE64ENCODE Function |
| ||||||
| BASE64DECODE Function |
|
Release 7.4
New Functions
| Function Name | Description | ||||||
|---|---|---|---|---|---|---|---|
| WEEKDAYNAME Function |
|
...
