Pivot on Large dimensional column in USQL


  • 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 
    // and

    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