DataStage Scenario?

[A_SUSHMA]

Hi All,

I have I/P is

EMPNO
1
2
3

I want O/P

EMPNO
1,2,3

[ssnegi]

In transformer create dummy deptno column and hard code 1.
Then in another transformer
deptno - partition hash, sort ascending
empno - no partition, sort only ascending

stage variable :
svempno :- if input.deptno = svdeptnold then svempnold :',': input.empno else input.empno
svdeptnold :- input.deptno
svempnold :- svempno

you can also modify the svempno stage variable to include the deptno :
svempno :- if input.deptno = svdeptnold then svempnold :',': input.empno else input.deptno:',':input.empno

[ray.wurlod]

Pivot.
Column Export.

[chulett]

I am seriously considering deleting posts that literally contain nothing but input and output examples. We must put an end to this madness. I cannot say this enough -

Spell out your requirements in words
Tell us what you've tried
Tell us what issues you've had

Do not simply drop off your dirty laundry here.