topic Re: How to transpose a table wihtout generic load in QlikView

How to transpose a table wihtout generic load

GLicks_DG — Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: How to transpose a table wihtout generic load

sunny_talwar — Wed, 12 Jun 2019 18:53:01 GMT

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

Re: How to transpose a table wihtout generic load

dplr-rn — Wed, 12 Jun 2019 18:59:13 GMT

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

Re: How to transpose a table wihtout generic load

GLicks_DG — Wed, 12 Jun 2019 20:05:07 GMT

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

sunny_talwar — Thu, 13 Jun 2019 11:06:03 GMT

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