14 Replies Latest reply: Apr 6, 2017 5:10 AM by Sunny Talwar RSS

    Sort first by Field1 and then by Field2

    Max Shevchenko

      Hi,

      How can I make sort first by Field1 and then by Field2?

       

      LOAD * INLINE [

      Name, DateEntering, DateGraduation

      Name1, 01/02/2010, 01/14/2017

      Name2, 01/02/2010, 01/15/2017

      Name3, 01/01/2010, 01/01/2017

      ];


      I need first sort by DateEntering and then by DateGraduation.

      As a result next


      Name, DateEntering, DateGraduation

      Name3, 01/01/2010, 01/01/2017

      Name1, 01/02/2010, 01/14/2017

      Name2, 01/02/2010, 01/15/2017


      Forgot to add that I need make it in an object properties.


      Thx.