Scenario

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
sudhana
Participant
Posts: 6
Joined: Mon Jan 30, 2012 2:48 pm

Scenario

Post by sudhana »

Hi All,

can any one please help me to solve the below query.

source:
empno, Sal
101,1000
101,2000
101,3000
102,1000
102,2000
102,3000

output:
empno,sal
101,1000
101,10002000
101,100020003000
102,1000
102,10002000
102,100020003000

Thanks In advance.
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 »

Search for "vertical pivot" and adapt one of the techniques.
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)”