I have data like
1. {
studentId: 1111
subject: math
grade: A
}
2. {
studentId: 1111
subject: history
grade: A
}
3. {
studentId: 2222
subject: math
grade: A
}
4. {
studentId: 2222
subject: history
grade: B
}
and want to have output as
studentId math . history
1111 A A
2222 A B
I used something like
stats list(subject), list(grade) by studentId
But the result is not what I wanted... Can anyone please help me with an example or something? Thanks a lot!
... View more