Hello,
I am stuck with an issue doing vertical pivot by pivot enterprise stage.
The issue is that sequence of columns generated from rows are not as expected. For ex:
I have the data as:
Sale1 100
Sale1 200
Sale1 300
Sale2 400
Sale2 500
Sale2 600
wants to convert as:
sale1 100 200 300
sale2 400 500 600
But the output is coming as:
sale1 200 100 300
sale2 600 500 600
Issue is that sequence is not coming proper for the columns as expected.
Please provide the solution.
problem in doing vertical pivot by pivot enterprise stage
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
Thanks for the reply
Yes you are right I haven't sorted the records and now it is working fine.
Aspirant