Pivot Enterprise Stage : Vertical Pivoting Steps

Pivot Enterprise stage:  Vertical Pivot Step by Step : DK®

This post will help you to implement pivot enterprise stage horizontal pivoting.

The Pivot Enterprise stage is a processing stage that pivots data horizontally and vertically.

Pivot Types:

1.   Horizontal Pivot
2.  Vertical Pivot

   *Click here to Know About Horizontal Pivoting

    Vertical Pivoting Step by Step :DK®

Vertical pivoting maps a set of rows in the input data to single or multiple output columns. The array
size determines the number of rows in the output data. The output data of the vertical pivot action
typically has more columns, but fewer rows than the input data. DK®

Input Data:

CUSTOMER_ID	CUSTOMER_NAME	Q1EXPENSE
1	UMA	100
1	UMA	200
1	UMA	300
2	POOJITHA	200
2	POOJITHA	300
2	POOJITHA	400

Output Data:DK®

CUSTOMER_ID	CUSTOMER_NAME	JAN_EXPENSE	FEB_EXPENSE	MAR_EXPENSE	Q1AVERAGE
1	UMA	100	200	300	200
2	POOJITHA	200	300	400	300

Create a job with Pivot enterprise stage, source and target stage. DK®

Now open Pivot enterprise stage and go the properties tab on stage page: DK®

 Now specify array size as 3 because we are have 3 months expenses in the quarter expense of in the input data and we need to convert into 1 row. DK®

Configure Mapping tab in the output page of the stage. DK®

Compile and run the job and check the output and this is your output. DK®