Concatenate multiple rows delimited by comma

[ysrini9]

Hi Team,

How to Concatenate multiple rows delimited by comma

Ex: I have a column

1025758
1025758-1025759
1025758-1025759-1025758-1025759

Output would be


1025758,1025758-1025759,1025758-1025759-1025758-1025759

Thanks and Regards
SHRINIVAS

[chulett]

That would basically be a "rows to columns" pivot, a.k.a a "vertical pivot" which an exact search here would reveal many informations on.

[ysrini9]

We are using Datastage datastage 8.1 only horizal pivot is possible.

Please let me know is there any other way

Thanks in Advance
SHRINIVAS

[chulett]

So in other words, you didn't do the search. There are many ways to pivot and not all involve that stage.

[swapnilverma]

if records are less you can use below simple unix shell script ..




cat filename | while read line do

{

x=$line:,:x

}

done

print $x >> op_file_name



Alternatively using transformer....

stage variable coltorow=''

coltorow=input.columnname:',':coltorow



i hope there are other better way around