How to convert row to columns using denormalizer or any step

[rajeshbcrec]

How to convert row to columns

[Mick_data]

Maybe using the Row De-normalizer step.
http://wiki.pentaho.com/display/EAI/Row+De-normalizer

Mick

[MattCasters]

Here is an example from Super Slawo: http://type-exit.org/adventures-with...lds-in-kettle/

[marabu]

One moment of hesitation might occur, when looking for an adequate input step.

[MattCasters]

Typically what you do is read the data line by line.
Then you hook up a bit of JavaScript since you need to determine an ID for each line, I'm asuming Event=0, Event=1, and so on.
You also split the data on the colon (:) and clean up the data a bit (description on the next line(s)).

Then the denormaliser step is used.

Happy hacking,
Matt

[marabu]

If you can't press the supplier of your data to conform to a more sane input specification, you will have to code a couple of lines.
The "Property Input" step delivers the description torn apart like this:

key----------------------------------------------------------------- value------------
description      
The Software Protection service entered the stopped state.

I suggest you throw in a User Defined Java Class to suppress the first row (key=description, value=none) and modify the following row by shifting the text to the value column and resetting the key to 'description'.

[marabu]

Why did you stop halfway?
You were almost done...

[MattCasters]

It's not that hard to do and we already told you how to do it. So I don't think anyone is volunteering to write this for you.