1 Reply Latest reply: Nov 3, 2012 5:02 AM by jagan mohan rao appala RSS

    sorting

    janardhan reddy

      Hi Friends ,

       

      I have two columns , like

       

      Hours                         worksoft.hours

      ---------------------------------------------------------

      orderning35,5             timelon 37,5

       

      orderning37,5             timelon 35,5

       

       

       

      I need Output like this :

       

      Hours                         worksoft.hours

      ---------------------------------------------------------

      orderning35,5             timelon 35,5

       

      orderning37,5             timelon 37,5

       

       

      Can Anyone help me how to sort

       

       

      Thanks inAdvace

      Janardhanreddy

        • Re: sorting
          jagan mohan rao appala

          Hi Janardhan,

           

          Try this script below

           

          Temp:

          LOAD * INLINE [

          Hours1,Hours2

          "orderning35,5",             "timelon 37,5"

           

           

           

          "orderning37,5",             "timelon 35,5"

          ];

           

          Test:

          LOAD

              RowNo() AS RowNo,

              Hours1

          RESIDENT Temp

          ORDER BY Hours1;

           

          Test2:

          LOAD

              RowNo() AS RowNo,

              Hours2

          RESIDENT Temp

          ORDER BY Hours2;

           

          DROP Table Temp;

           

           

          Hope this is what you are expecting.

           

          Regards,

          Jagan.