Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
prees959
Creator II
Creator 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
2 Replies
sunny_talwar

Check here

The Crosstable Load 

prees959
Creator II
Creator II
Author

Thanks ! Works perfectly