Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

...

join and union transforms have dedicated pages for configuring this transformations. You can enter join or union as the transformation to open the corresponding tool.

For a list of available transformations, see Transformation Reference.

...

A number of transforms support the following parameters.

D s ordering
Group parameter: For transforms that aggregate data, such as 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
Typestep
p01NameRow labels
p01ValueStore_Nbr
p02NameValues
p02Valuesum(POS_Sales)
SearchTermPivot columns

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
p03Valuesum(Sales)
Typestep
p01NameRow labels
p01ValueStore_Nbr
p02NameColumn labels
p02ValuecontractDate
p03NameValues
SearchTermPivot columns

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
p03ValuecolC
Typestep
p01NameFormula type
p01ValueSingle row formula
p02NameFormula
p02ValuecolA + colB
p03NameNew column name
SearchTermNew formula

Step 3 - Specify other parameters

...