Create a Matrix based on Table

[#1]

Hi people,

Using Qlikview is possible to transform a table like that:

ID	A	B
1	15	30
2	20	43

Into this:

ID	TEST	GRADE
1	A	15
1	B	30
2	A	20
2	B	43

The represents the student and each A and B a different test... My original database migrate the data in the first format but I needed into the second...

Regards

[hectorvega]

Use CrossTable.

You could find a nice video showing how to do it on this url Power of Qlik Script - Reshaping Data with Crosstable (video)

Hope this help.

[kaushiknsolanki · Accepted solution]

Hi,

Yes its possible. You can use the Crosstable Function.

Data:

CROSSTABLE(Test,Grade,1)

Load ID,

        A,

        B

From Xyz;

Regards,

Kaushik Solanki