Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. $300 savings extended to February 9th Learn More
Highlighted
prees959
Contributor II

Transpose from Columns to Rows

Hi,  I have the following xls table :

 

 12345
aaa *                  -                -                   -                -  
bbb *         12,995       6,445          4,885       3,235
ccc         -            7,970       6,385          3,460          145
ddd *                  -         3,045          2,250       2,310
eee         -          15,070       3,110          5,495       1,165
fff         -               540            55             345             45
ggg         -               955            95             730             20
hhh         -               160              -               280             55
iii         -               115            70             170             80
jjj         -                   -                -                   -                -  
kkk         -               305              -            2,280          325
lll         -                   -                -                  30              -  
mmm         -                   -                -                   -                -  
nnnn     230                 -                -                   -                -  

 

Is it possible to transpose this during the load so I can get :

CODEIDValue
aaa1              21
bbb1 * 
ccc1               -  
ddd1              22
eee1                2
fff1               -  
ggg1              12
hhh1               -  
iii1               -  
jjj1            443
kkk1               -  
lll1              23
mmm1              32
nnnn1            230
aaa2            234
bbb2       12,995
ccc2         7,970
ddd2               -  
eee2       15,070
fff2            540
ggg2            955
hhh2            160
iii2            115
jjj2               -  
kkk2            305
lll2               -  
mmm2               -  
nnnn2               -  

 

etc

etc

 

Many thanks for any help

 

Phil

Labels (1)
1 Solution

Accepted Solutions

Re: Transpose from Columns to Rows

2 Replies

Re: Transpose from Columns to Rows

prees959
Contributor II

Re: Transpose from Columns to Rows

Thanks ! Works perfectly