DSXchange

Hi,

I need to o/p the result in below format.
I/P
col1
1
2
3
4
5
6
7

O/P
Co1
1,2,3,4,5,6,7

Thans in advance.

Rgds

Hi,

Use the pivot stage to achieve this.

Naveen.

Naveen,

I think Pivot will not help as I need one column for all rows

colA -I/P
1
2
3
4

o/p
colB

1234

rgds


[quote="naveendronavalli"]Hi,

Use the pivot stage to achieve this.

Naveen.[/quote]

I think the Pivot stage do the reverse: read one row and write multiple rows. Can Pivot stage do read multiple rows and combine them into one?

Thanks,

No it does not ...that is what we are sruggling for :-)

[quote="olgc"]I think the Pivot stage do the reverse: read one row and write multiple rows. Can Pivot stage do read multiple rows and combine them into one?

Thanks,[/quote]

Cannt we use row merger stage??

"The row merger stage reads data one row at a time from an input link. It merges all the columns into a single string of a specified format. It then writes the string on a given column of the output link. The stage can have a single input link and a single output link."

Hi Shrey,

Sorry about that. As Deepak said row merger stage will get it done.

Thanks,
Naveen.