Pivoting 1 or more groups in a singel stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
shivadrash
Participant
Posts: 8
Joined: Mon Jun 13, 2011 2:55 am
Location: india

Pivoting 1 or more groups in a singel stage

Post by shivadrash »

Can you please guide me in this following scenario?
I have an input source with the following attributes in my input.

Key,NumericType1,NumericValue1,NumericType2,NumericValue2,NumericType3,NumericValue3,CharType1,CharType2,CharType1,CharType2

I need to pivot Numetic TYpe and CharType as below

Key,NumericType,NumericValue,CharType,CharValue

Iss this possible? I tried grouping, and assignt keys, but no luck. Requesting ur help
Regards
Sivanandha
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Is this a WebSphere Transformation Extender (WTX, formerly known as DataStage TX) question?

If not, please post your question in the correct forum.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”