none
How to use data values of column as column names and filter results dynamically in u-sql

    Question

  • 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 !

    Tuesday, November 21, 2017 10:04 AM