Page 1 of 1

target Format

Posted: Wed Sep 29, 2004 11:27 pm
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.

Posted: Thu Sep 30, 2004 1:34 am
by ray.wurlod
Pivot stage to do the pivot.
Use constants in the pivot stage to generate the month names.