target Format

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Kniranjani
Participant
Posts: 8
Joined: Mon Jul 12, 2004 9:17 am

target Format

Post by Kniranjani »

Hi all,
Please give the solution for my doubt.
If iam having the sourceformat like
SRepresent jan feb march
1 120 130 120
2 100 900 500
3 300 400 500
I want target in the folloring format
SRep Month Sales
1 Jan 120
1 feb 130
1 march 120 etc..
Please let me know how i can do this.

Thanks,
Niranjani.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Pivot stage to do the pivot.
Use constants in the pivot stage to generate the month names.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply