The following changes have been applied to  in this release of .

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 NameDescription
Decimal SeparatorThe string used to separate the integer part of a Decimal value from its fractional part.
Grouping SeparatorThe string used to separate a group of digits. 

For more information, see NUMFORMAT Function.

New functions

Function NameDescription
NUMVALUE Function

Release 8.4

New functions

Documentation for the following functions is now available.

Function NameDescription
FINDNTH Function

PARSESTRING Function

PARSEARRAY Function

PARSEOBJECT Function

Release 8.3

None.

Release 8.2

None.

Release 7.10

New functions

Function NameDescription
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 NameDescription
All

Selects all columns in the dataset

Example:

The following is the list of the transformations that accept the All option for selecting 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 NameDescription
Convert to lowercase

Converts existing column names to lowercase

Convert to UPPERCASEConverts 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 NameDescription
APPROXIMATEMEDIAN Function

APPROXIMATEPERCENTILE Function

APPROXIMATEQUARTILE Function

base64 encoding functions:

Function NameDescription
BASE64ENCODE Function

BASE64DECODE Function

Release 7.4

New Functions

Function NameDescription
WEEKDAYNAME Function