How to convert multiple rows of data into single row

[adams06]

Hi,


How to convert multiple rows of data into single row?

ex: input

field1

a
b
c
d

output:

a,b,c,d

[prabu]

Hi,


How to convert multiple rows of data into single row?

ex: input

field1

a
b
c
d

output:

a,b,c,d

1)pivot stage

[adams06]

Hi Prabu,

can you explain in detail

Thanks

Hi,


How to convert multiple rows of data into single row?

ex: input

field1

a
b
c
d

output:

a,b,c,d

1)pivot stage

[thumsup9]

Look at this link !


viewtopic.php?t=87824&highlight=vertical+pivot

Thanks,

[Luciana]

The pivot stage reads 1 row with 4 columns and it generates 4 rows with 1 column.

If you you want to read multiple rows (1 column) into single row with the content of the column field1 of all rows, use ROW MERGE stage, but include transforms stage before the row merge stage for connects ";" in the end of the column.

Ex.:
Input --> Transformer --> Row Merge --> Output
a --> a : ";" -->
b --> b : ";" -->
c --> c : ";" -->
d --> d : ";" --> --> a;b;c;d

[meena]

Hi adams06...
You can use "row merger active plug-in stage" and Luciana as explained you in detail..Let us know if you do not have row merger plugin stage......