Transformation of Table

[#1]

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

[#2]

Hi,

It can possible with cross table.

[buzzy996]

try this,simply load ur table1 data in qlikview.

use cross table.

move ur columns as rows

[awhitfield]

Hi Priya,

you should check out the following post, which has some pretty useful examples:

http://community.qlik.com/thread/64678

Cheers Andy

[#5]

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.

[maxgro]

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()

));

[#7]

Hi Massimo,

Thanks for your reply.

Can you help me with the solution.

please find attached sample file.

Thanks in advance

Regards,

Priyanka