problem in doing vertical pivot by pivot enterprise stage

[sanygup]

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.

[priyadarshikunal]

I haven't checked the vertical pivot yet but the first thing which comes to my mind is did you sort the records before sending it to pivot stage? and prevented pivot stage from re-sorting and re-partitioning?

[sanygup]

Yes you are right I haven't sorted the records and now it is working fine.