AGGR()

[#1]

I want to create a new table with a new field in the load script, this field ahould be calculated as following

AGGR(MAX(DATE),AGENT)

But, as I understand, this function is only for set analysis. Is there an opportunity to make such field using other functions?

[sunny_talwar]

You can do something like this:

Fact:

LOAD Date,

          Agent,

          OtherFields...

FROM Source;

AggregatedTable:

LOAD Agent,

           Max(Date) as MaxDate

Resident Fact

Group By Agent;