Get the average of time using Interval in Load Script

[#1]

Hi there,

How can I get the below code to work in the load script. Aggr gives me an error

(AVG(Aggr([COR DATE] - [CO DATE] ,TRACE_NUMBER,TRACE_NUMBER)),'dd hh:mm:ss')

Your soonest response will be highly appreciated

Regards,

Mpho

[rwunderlich]

aggr() is not valid in script. The logical equivalent in script would be GROUP BY.

-Rob