vertical pivot is hanging
Moderators: chulett, rschirm, roy
vertical pivot is hanging
Hi,
I have i/p as
id date gp code amt
1 1992-01-01 US abc 123
1 1992-01-01 US abc 124
1 1992-02-01 US abc 234
1 1992-03-01 US abc 245
Expected o/p
id gp code jan feb march april june july aug sept oct nov dec
1 US abc 247 234 245
i used pivot stage and type as vertical pivot . group by by id,gp,code and pivot column amt, array size 12
i am getting o/p as
id gp code jan feb march april june july aug sept oct nov dec
1 US abc 123 124 234
not sure where i am going wrong and also iam sending sorted data to pivot stage . Any suggestions please.
Thanks
I have i/p as
id date gp code amt
1 1992-01-01 US abc 123
1 1992-01-01 US abc 124
1 1992-02-01 US abc 234
1 1992-03-01 US abc 245
Expected o/p
id gp code jan feb march april june july aug sept oct nov dec
1 US abc 247 234 245
i used pivot stage and type as vertical pivot . group by by id,gp,code and pivot column amt, array size 12
i am getting o/p as
id gp code jan feb march april june july aug sept oct nov dec
1 US abc 123 124 234
not sure where i am going wrong and also iam sending sorted data to pivot stage . Any suggestions please.
Thanks
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
For starters, don't push. Your last two posts were at 10:48pm and 1:22am my time. DSXchange is an all volunteer site whose members post if and when they can, at the same time being under no obligation to do so.
If you effect the pivot using a Transformer stage, does it still hang?
How, precisely, are you configuring the PXPivot stage?
If you effect the pivot using a Transformer stage, does it still hang?
How, precisely, are you configuring the PXPivot stage?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.