DSXchange

In Datastage parallel edition, how can we combine the rows coming from the input link into a single row. Say for example:-

I/P:-

COLA
---------
A
B
C
D

O/P:-

COLB
-------
ABCD

It sounds something like vertical pivoting but here the number of columns at both ends are equal..

I'm having only one column at the input but at the output the coulmn length should be very large to accomodate all the records.

Any help will be appreciated greatly..

Wonder why someone will need to do that.

Especially if there is only one column.

The options are
1.) if output is seq file, write with rec delim as none.
2.) if source is seq file, you can remove newline using unix utilities.

Thanks for the help i got it..

Sainath.Srinivasan wrote:Wonder why someone will need to do that.

Especially if there is only one column.

The options are
1.) if output is seq file, write with rec delim as none.
2.) if source is seq file, you can rem ...

hey yar try to giv the answer okies.

Subhajit,

Pls reply in proper professional language.


Regards
Sreeni

cat filename | tr '\n' ' '

cat filename | tr '\n' ' '