Question

Abbasi.F on Tue, 21 Nov 2017 10:04:33


Class Names | count | Date

Vessel      | 2     | 14 nov
CFP         | 1     | 14 nov
CFP         | 2     | 15 nov
CFP         | 8     | 17 nov
Vessel      | 4     | 15 nov

I want to output it like the following:

        14 nov | 15 nov | 17 nov | ....
Vessel     2        4        0       0        
CFP        1        2        8       0       
....

so the result should be a matrix type, the rows should say the class Names(the values inside className column) and columns should say the dates(the values of date column). The dates inside date column could be infinitely many and not known at compile time, and same for classNames. So, it should check the values inside Date and class Names column, and extract the count value based on those values.

Thanks, your help will be appreciated !