...
A number of transforms support the following parameters.
| D s ordering |
|---|
pivot or window, you can specify the column by which you wish to group the computed aggregations. In the following example, all values in the POS_Sales column are summed up for each value in the State Store_Nbr column.| d- |
|---|
...
| trans | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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:
| d- |
|---|
...
pivot value:SUM(Sales) group:State order:contractDate
| trans | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 derive and 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 colA and colB are summed and written to the new column colC:
| d- |
|---|
...
| trans | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Step 3 - Specify other parameters
...
