PDA

View Full Version : Dont know how to do the following:



kettle_anonymous
03-08-2006, 05:01 AM
Hi,
I am not sure how i can archieve the following, if at all possible i want to transform table1 to table2. Is this possible?

Table1:
id measuretype value

1 5 somevalue1
2 7 somevalue2

Table2:

id measuretype5 measuretype7
1 somevalue1 somevalue2

MattCasters
03-08-2006, 05:13 AM
Sure, this is possible except for the ID, I don't think this is correct.

Shouldn't the input be like this?

id measuretype value
1 5 somevalue1
1 7 somevalue2

In that case, you can use the "Row Denormaliser" step to do this.
The key-value pair is measuretype-value

Specify the id in group, the target field and the key to look for.

Hope this helps,

Matt