Use the Transpose Data in Hadoop directive to transpose
one or more columns in a source table into rows in a target table.
The columns in the target are the values of a specified column in
the source. For example, you could specify that the columns of the
target be taken from the values of a source table column that contains
customer ID numbers. Each unique customer ID value in the source becomes
a separate column in the target.
You do not have to transpose
all of the columns in the source. You can select source columns that
will be copied directly to the target.
This directive contains
embedded help that includes examples of the transposed data.