Category: azure data lake
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 !