none
Pivot on Large dimensional column in USQL

    Question

  • Hi

    I am new to USQL, (and SQL for that matter). I am trying to pivot on a column that has around 600 different values and hopefully wish to create 600 columns using its values (These will be features that will be fed into a machine learning algorithm). 

    I really don't want to manually put in the 600 values manually into the pivot IN statement. I tried using the example from 

    https://github.com/Azure/usql/blob/master/Examples/AmbulanceDemos/AmbulanceDemos/3-Ambulance-User%20Code/3.2-Ambulance-UseUDOs.usql 
    // and https://github.com/Azure/usql/blob/master/Examples/AmbulanceDemos/AmbulanceDemoCode/Class1.cs


    But the outputter only returns the non-map elements. Could you please help me understand how to do this?

    Sunday, October 15, 2017 5:13 PM

Answers