I have a question: What's the equivalent or alternative of "max" in load sript? I'm doing an aging report and I must base my starting point as the last payment or last due date. So I want to get the max(due_date) for each account so I can start the aging. But unfortunately, "max" is not allowed or invalid to use in the load script. Is there an alternative for "max" in the load script? Or is there any other work around for this problem?
First you have to group the records on 'account' . then again sort in ascending order on same. Now your are having the max(due_date) as the last record value for each account. Now use PEEK function to fetch the last record account wise. Your work is done.