Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
GLicks_DG
New Contributor

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:

MonthCol ACol BCol C
Jan102030
Fev510

15

 

My goal is to reach something like:

MonthColumnValue
JanCol A10
JanCol B20
JanCol C30
FevCol A5
FevCol B10
FevCol C15

 

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!

1 Solution

Accepted Solutions

Re: How to transpose a table wihtout generic load

You don't need a generic load here, but The Crosstable Load

4 Replies

Re: How to transpose a table wihtout generic load

You don't need a generic load here, but The Crosstable Load

Partner
Partner

Re: How to transpose a table wihtout generic load

generic load is the reverse of what you are trying to achieve. Like sunny said you need cross table load
GLicks_DG
New Contributor

Re: How to transpose a table wihtout generic load

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

Re: How to transpose a table wihtout generic load

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