We have moved to www.dataGenX.net, Keep Learning with us.
Showing posts with label horizontal. Show all posts
Showing posts with label horizontal. Show all posts

Thursday, July 11, 2013

Convert a single row into multiple rows ( horizontally pivoting ) with Pivot stage ?


In this example, the Pivot Enterprise stage is set up to horizontally pivot some data.
You can generate a pivot index that will assign an index number to each row within sets of horizontally pivoted data. The following tables provide examples of data before and after a horizontal pivot operation.


Input 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.22
102,Xing,2190.89,1287.98,2054.55
103,Anderson,1498.09,1287.23,3298.76