5 Replies Latest reply: Oct 6, 2014 5:53 AM by Herbert Chitate RSS

    Order by & Group by

      Hi All,

       

      How can I use order by and group by together. Order by only works using a resident load. When I try to take the short cut

      Load *

      Resident XYZ

      Order by [Received Date] asc;

       

      And then another load statement to group, this doesnt work.

       

      In the resident load, do I need to specify all fields and not use Load *?

      Can I use Load * when I do the group by part?

       

      Because this seems like a long repetition of the script.

       

      Thanks

       

      H