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.