Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to rotate values into dimension with qlikview

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:

IDCodeValue
1A3
1B2
1C1
2D4

I would like to have this:

ID
A

B

C
D
1321
2


4

Thank you in advance,

Best Regards

1 Solution

Accepted Solutions
jeffmartins
Partner - Creator II
Partner - Creator II

Hi laguerrethom,

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

Regards 

View solution in original post

3 Replies
Not applicable
Author

Hi,

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

Transformation Step -> Rotate -> Transpose

screenshot.2.jpg

screenshot.3.jpg

Regards

MC

jeffmartins
Partner - Creator II
Partner - Creator II

Hi laguerrethom,

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

Regards 

Not applicable
Author

Thank's a lot Jeffmartins,

it's roughly what I needed.