Crosstable

[vBonini]

Hi, I have a table like this:

myTable:

load 

ListOfColumns   ,

ListOfValues,

OtherField

resident AnotherTable;

ListOfColumns   ListOfValues   OtherField

column1            value1               othervalues

column2            value2               othervalues

column3            value3               othervalues

I would like to have a table where all the values of ListOfColumns  are the columns, and the values of ListOfValues are the column values:  (I don't need the column OtherField)

column1    column2     column3

value1       value2         value3

How can I obtain this?

[Vegar]

You can use Generic Load for this.

See Qlik Help - Generic 

You can also have a look at Henric Cronströms (HIC) excellent blog post from 2014: The Generic Load