The following changes have been applied to in this release
Nest transformation explicitly types transformed column
In prior releases, when a Nest transformation was applied to a column to nest values into Arrays or Objects, the resulting column was re-inferred by the . This re-inference should not be necessary, since the target column's data type is effectively declared in the transformation definition.
Beginning in this release, the output column of these Nest transformations is explicitly typed to Array or Object data type, based on the definition of the transformation.
NOTE: Existing uses of the Nest transformation are not immediately affected. However, if these transformations are edited, then the changes may cause unexpected results and breakages in downstream transformations. If the recipe was originally designed expecting a different data type, subsequent steps may have been used to clean up the nested data, assuming that it was String values or some other data type. If the output column is now explicitly typed as Array or Object data type, these steps may be broken. You may be able to fix these broken steps by explicitly typing the output column to String after the Nest transformation and before your subsequent steps.
For more information, see Nest Your Data.
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: You can now do faster iteration since you can add new positions as needed when previewing the transformation.
For more information, see Split Column.
Support for numeric separators in NUMFORMAT function
Beginning in Release 8.5, the NUMFORMAT function supports the following configurable separators for localizing numeric values:
|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.
|D excerpt include|
Documentation for the following functions is now available.
|D excerpt include|
|D s also|
|label||label = "language" or label = "wrangle"|