Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Yes its possible. You can use the Crosstable Function.
Data:
CROSSTABLE(Test,Grade,1)
Load ID,
A,
B
From Xyz;
Regards,
Kaushik Solanki
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.
Hi,
Yes its possible. You can use the Crosstable Function.
Data:
CROSSTABLE(Test,Grade,1)
Load ID,
A,
B
From Xyz;
Regards,
Kaushik Solanki