Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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.