NOTE: Sort is intended primarily for display purposes in the Transformer page.
When When a column is sorted in ascending order, the bottom values are mismatched and null values, in that order. These values appear at the top of the column when sorted in descending order.
Calculate a new column containing the values computed from the source column based on the selected function. This command does not apply to all data types.
Create column from examples
Using a source column, you can create a new column using the source values as examples.
Tip: The transformation-by-example feature can be used in place of standardization or extraction transformations and may be simpler to use.
For more information on transformation-by-example, see Overview of TBE.
Group by minimum or maximum value, counts, or arbitrary function. See Create Aggregations.