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: 
plaatkoek
Contributor II
Contributor II

Transpose more than 1 column into rows in script

Hi

I'm quite new here and have been searching the community for an answer on this, but none of the solutions have worked yet.

I need to transpose multiple columns to multiple rows in the Load Script via Qlikview.

The attachment shows how the data is and how I need the data.

I can do it quite easily with Excel, but don't want another step in the process.

Thanks in advance!

As is.png

To be.png

1 Solution

Accepted Solutions
marcus_sommer

2 Replies
marcus_sommer

Take a look here: The Crosstable Load.

- Marcus

plaatkoek
Contributor II
Contributor II
Author

Hi Marcus

Thanks, it wasn't quite what I was looking for, but in the end it helped me on the right path.