all rows in one column

[shrey3a]

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

[I_Server_Whale]

Hi,

Use the pivot stage to achieve this.

Naveen.

[shrey3a]

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]

[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,

[shrey3a]

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]

[DeepakCorning]

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."

[I_Server_Whale]

Hi Shrey,

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

Thanks,
Naveen.