Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

convert row to column


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

....

Labels (1)
0 Replies