Vertical Pivoting

Vertical pivot operation

We can do vertical pivoting  using xtf and Pivoting Enterprise Edition

Source Data

Use the Pivot Enterprise stage to vertically pivot data and then map the resulting columns onto the output columns.

Pivot Type

Specify Horizontal to map columns into rows or Vertical to map rows into columns.

You can specify on which processing nodes the stage processes are run, and constrain the stage to use certain resources.

Use the Checksum stage to generate a checksum value from the specified columns in a row and add the checksum to the row

Typically you create the Checksum stage in one job to add the checksum column, and then use a Checksum stage in another job to check the validity of the data.

Output

Thanks & Regards,
Siva.