1 Reply Latest reply: Apr 20, 2016 10:15 AM by Sunny Talwar RSS

    Is it possible to do randomise the field to Order By?

    John Blomqvist

      Hi all,

       

      Let's say I have the following table:

       

      LOAD
      OrderID,

      OrderDate,

      CustomerID,

      ProductID

      Value

      Resident <table>

      Order By OrderDate

       

      Is it possible in the above to randomly swap the field to order by?

       

      Say it's OrderDate but in the next reload it can randomly order by CustomerID or ProductID.

       

      How is it possible to do this? Any ideas?