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