Hi I have fields like this in my source
studentID name sub1 sub2 sub3 sub4
I need my target to be populated as
studentID name sub marks
Here the Column name viz Sub1, Sub2, Sub3, Sub4 will populate sub field and corresponding marks will be in marks field.
Every one row will populate 4 rows in target.
Please tell me a solution ASAP
Lucky,
Splitting a Row
Moderators: chulett, rschirm, roy
Re: Splitting a Row
I dont have a pivot stage.
I am working on 5.2 version. Alternate solution is appreciated.
Please help
Lucky
I am working on 5.2 version. Alternate solution is appreciated.
Please help
Lucky
-
- Premium Member
- Posts: 385
- Joined: Wed Jun 16, 2004 12:43 pm
- Location: Virginia, USA
- Contact:
The pivot stage is available on 5.2. I used it in many jobs in the past.
Upgrade anyway.
Upgrade anyway.
Chuck Smith
www.anotheritco.com
www.anotheritco.com
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If it's not installed, you install the Pivot stage (or any other optional ("plug-in") stage using the Package Installer, which is on the server.
You will need your DataStage CD; the software is in a directory called Packages.
There may also be a client component, which you install on your client machine using a regular Windows install.
Within the Packages folder for each stage type, there is also a folder called Docs. In pivot.pdf you will find that one of the examples is almost exactly what you are trying to do (only three pivot columns rather than four).
You will need your DataStage CD; the software is in a directory called Packages.
There may also be a client component, which you install on your client machine using a regular Windows install.
Within the Packages folder for each stage type, there is also a folder called Docs. In pivot.pdf you will find that one of the examples is almost exactly what you are trying to do (only three pivot columns rather than four).
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.