DSXchange

Hi ,
I am getting input data as follow in a sequential file:

a: test us,osjkjkj
b: ab
c: defhj

a: tes1t usa,osjkjkj
b: cd

a: tt usa,osjkjkj
b: ef
c: ghij
d: defhj

Required output format is :

a|b|c|d
test us,osjkjkj|ab|defhj|NULL
tes1t usa,osjkjkj|cd|NULL|NULL
tt usa,osjkjkj| ef|ghij| defhj

Note: a,b,c,d are column names

I am not sure how to achieve this result . Please advise which stage i can use to achieve this in datastage .

You can pass your source file through a simple script where you can replace enter character with comma or some other delimiter and then
blank lines with enter chacter and change.

Thanks,
Nitin Swarnkar

Search DSXchange for "vertical pivot", for this is what you are trying to accomplish.