pivot: syntax and options

The syntax and options of the pivot operator.


pivot -horizontal
-derive field_name
-from  field_name [-from  field_name]...
-type type 
[-derive field_name
-from  field_name [-from  field_name]...
-type type]...
[-index field_name]

Table 1. Pivot options
Option Use
-horizontal -horizontal

Specifies that the operator will perform a horizontal pivot operation.

-derive -derive field_name

Specifies a name for an output field.
-from -from field_name

Specifies the name of the input field from which the output field is derived.
-type -type type

Specifies the type of the output field.
-index -index field_name

Specifies that an index field will be generated for piviotted data.