How to rotate values into dimension with qlikview

[#1]

Hello EveryBody ,

I would like to know how i can transform my values from lines to column with my script during a load statement. Let's look at this example :

I have this:

ID	Code	Value
1	A	3
1	B	2
1	C	1
2	D	4

I would like to have this:

ID	A	B	C	D
1	3	2	1
2				4

Thank you in advance,

Best Regards

[#2]

Hi,

have a look at using the transformation step on step 2 of the table wizard in load script.

Transformation Step -> Rotate -> Transpose

Regards

MC

[jeffmartins · Accepted solution]

Hi laguerrethom,

I had the same problem and solved it with the code described in the attached file.

Regards 

[#4]

Thank's a lot Jeffmartins,

it's roughly what I needed.