Transpose multiple column row values to one (using Javascript?)

[Jasper]

Hi,

I would like to transpose a list of around 200 subsequent row values in one column into 1 row/field value. I am generating a dynamic SGL statement.

As far as I know there is no standard step that could do this, right?

Example:


Column1
---------------------------
row1 | A
row2 | B
row3 | C
..
row200 | X


Should become:

Column1
-------------------------
row1 | ABC..X



Could this be done using Javascript? or is JS only capable of doing single row oriented transformations?

Thx

[darrell.nelson]

I would think you could make the Row Flattener step perform this operation.

[Jasper]

Hi Darrell,

I looked into that but the Row Flattener divides multiple row belonging to a certain group into multiple columns. Moreover you have to know the number of result columns upfront, so it is not dynamic.



Funny is that I found an example of exactly the opposite of what I want to achieve in the kettle samples (using javascript);
(see "Javascript create new rows" sample)

[gutlez]

Group By?
Concatenate values option?

[MattCasters]

I'm so proud of you gutlez. Finally someone to help me in my quest to eradicate JavaScript in ETL!

[Jasper]

Thank you Gutlez!

That will do just fine.