Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I want to convert table1 into table2. Please help.
Table1:
Student | Paper-I | Paper-I | Paper-I | Paper-II | Paper-II | Paper-II | Paper-III | Paper-III | Paper-III | Paper-IV | Paper-IV | Paper-IV |
Type | External | Internal | Practical | External | Internal | Practical | External | Internal | Practical | External | Internal | Practical |
A | 41 | 33 | 32 | 37 | 31 | 39 | 39 | 32 | 37 | 43 | 30 | 45 |
B | 39 | 34 | 47 | 31 | 29 | 44 | 38 | 33 | 47 | 45 | 37 | 49 |
C | 28 | 27 | 37 | 32 | 29 | 44 | 38 | 32 | 44 | 28 | 31 | 48 |
D | 36 | 32 | 47 | 44 | 35 | 49 | 34 | 31 | 47 | 29 | 27 | 45 |
Table2:
Student Name | Paper | Type | Marks |
A | Paper-I | External | 41 |
A | Paper-I | Internal | 33 |
A | Paper-I | Practical | 32 |
A | Paper-II | External | 37 |
A | Paper-II | Internal | 31 |
A | Paper-II | Practical | 39 |
A | Paper-III | External | 39 |
A | Paper-III | Internal | 32 |
A | Paper-III | Practical | 37 |
A | Paper-IV | External | 43 |
A | Paper-IV | Internal | 30 |
A | Paper-IV | Practical | 45 |
Regards
Priyanka
Hi,
It can possible with cross table.
try this,simply load ur table1 data in qlikview.
use cross table.
move ur columns as rows
Hi Priya,
you should check out the following post, which has some pretty useful examples:
http://community.qlik.com/thread/64678
Cheers Andy
Hi Priya,
you can use cross table function or you can attach your file so i can work on that and send back to you.
it seems ok
CrossTable(Student, Marks, 2)
LOAD Student as F1,
Type,
A, B,
C, D
FROM
[http://community.qlik.com/thread/157623]
(html, codepage is 1252, embedded labels, table is @1, filters(
Transpose()
));
Hi Massimo,
Thanks for your reply.
Can you help me with the solution.
please find attached sample file.
Thanks in advance
Regards,
Priyanka