A number of transforms support the following parameters.
|D s ordering|
window, you can specify the column by which you wish to group the computed aggregations. In the following example, all values in the
POS_Salescolumn are summed up for each value in the
Assuming that there are entries in the
State column for each state in the United States
Store_Nbr column, the resulting transform step has 50 rows, each of which contains the total sales for the listed statestore number.
Order parameter: Some transforms support the
order parameter, which allows you to specify the column of values that are used to sort the output. In the following example, all aggregates
Sales values are ordered by the contract date and grouped by State:
pivot value:SUM(Sales) group:State order:contractDate
The output can always be ordered using the
sort transform. See Sort Transform.
New Column Name parameter: For transforms that generate new columns, such as
extract, you can optionally specify the name of the new column, which saves adding a step to rename it. In the following example, the values of
colB are summed and written to the new column
Step 3 - Specify other parameters