Pivot Enterprise stage 8.5

Horizontally Pivoting 

Pivot Enterprise edition is enhance version of previous version of Pivoting Stage

1. In previous version we used to have horizontal Pivoting(H.P)
2. In Pivot Enterprise version we can do horizontal version and vertical pivoting  along with aggregating functions.  
3. they have Introduced Pivot Index Column
4. H P:- converting Columns to rows in Horizontally placed columns 
5. V.P:  rows to columns in Vertically  Converting 

Example--Source Data

REPID,last_name,Jan_sales,Feb_sales,Mar_sales

100,Smith,1234.08,1456.80,1578.00

101,Yamada,1245.20,1765.00,1934.22x

Source Data

Design your basic job by doing the following tasks:


Seq_File------->Pivot Enterprise---------->Dataset

 Here we are making horizontal pivot so Select Horizontal Type

 Map to Input columns to Output 

 HERE WE CAN SEE one more advance feature is pivot index

1)here i don't want appear all sales data...so delete all columns and create new column to appear all data in rows

2)in new column double click on that and select rows selected ones

 Output data for a simple horizontal pivot operation

Thanks & Regards

Siva