I am new to qlikview. I want convert a row to column.
The input is like this-
column1 companycode1 column2 companycode2 companycode3.......companycode12
a
b
c
d
e
My output should be like:
a b c
companycode company name 1 2 3 4 5 1 2 3 4 5 1 2 3 4 5 column2
companycode1 cn1
companycode2 cn2
companycode3 cn3
....