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

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
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

....

0 Replies