Discussion board where members can get started with QlikView.
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:
My goal is to reach something like:
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!
Go to Solution.
You don't need a generic load here, but The Crosstable 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