
Contributor III
2019-06-12
02:34 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to transpose a table wihtout generic load
Hi everyone, I'm new on qlikview and I could use some help.
Currently I'm trying to transpose a given table as the one below:
Month | Col A | Col B | Col C |
Jan | 10 | 20 | 30 |
Fev | 5 | 10 | 15 |
My goal is to reach something like:
Month | Column | Value |
Jan | Col A | 10 |
Jan | Col B | 20 |
Jan | Col C | 30 |
Fev | Col A | 5 |
Fev | Col B | 10 |
Fev | Col C | 15 |
I read some posts about using Generic Load to do so, but the actual table I'm working on has 12 rows and around 10000 columns so i won't be able to explicitly load everything.
Any suggestions? Thanks in advance!
935 Views
1 Solution
Accepted Solutions

MVP
2019-06-12
02:52 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You don't need a generic load here, but The Crosstable Load
929 Views
4 Replies

MVP
2019-06-12
02:52 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You don't need a generic load here, but The Crosstable Load
930 Views

Partner - Master III
2019-06-12
02:59 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
generic load is the reverse of what you are trying to achieve. Like sunny said you need cross table load

Contributor III
2019-06-12
04:05 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It worked, appreciated!
The final script looked something like this:
OutputTable:
CrossTable(Column,Value)
LOAD * Resident InputTable
Anyhow, do you happen to know how CorssTable handles missing values?
Thank again
The final script looked something like this:
OutputTable:
CrossTable(Column,Value)
LOAD * Resident InputTable
Anyhow, do you happen to know how CorssTable handles missing values?
Thank again
913 Views

MVP
2019-06-13
07:06 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
What do you mean? Are you saying if there is a cell with a null... would that be converted to a row? Yes it will be.... but if you don't need it, you can remove nulls from the resident load
895 Views
