Create a Pivot Without Knowing the Columns Before Hand RRS feed

  • Question

  • I need to create a pivot on some columns that I don't know at run time.  Is this possible using the PIVOT operator in USQL?  Again, I don't know the columns at run time so this would have to be dynamic in some way.  So I have a rowset that has mbr_id, Age, and Pred.  I want to pivot on Age but I don't know how many different Ages I will have in the rowset.  Thanks.

    Brian L Custer

    Tuesday, November 28, 2017 10:42 PM