Pivot stage is used in what conditions?
Could someone help me out!!!!
What is the use of pivot stage?
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 252
- Joined: Mon Sep 19, 2005 10:28 pm
- Location: Melbourne, Australia
- Contact:
To convert 1 input row into 2 or more output rows. For example, you could pivot a row that contained:
into
In this example the output would contain 12 rows for every input row.
Code: Select all
Department, Year, Sales_Jan, Sales_Feb, Sales_Mar, ...
Code: Select all
Department, Year, Month, Sales
Ross Leishman