Save the highest value into another field

[#1]

Hi,

I have a numeric field called 'debe' and I would like to add a new field called 'maximun' containing the highest value in the 'debe'.

Something like:

load

debe,

maximun(debe) as maximun

from...;

Which command / sintax I need?

Thanks

[JonnyPoole · Accepted solution]

This will do it. Joins the record with the max(debe) to all records in the load and stores the max under the new field MaxDebe

Debe:

LOAD

     debe

FROM

<Source>

;

left join (Debe)

load

  max(debe) as MaxDebe

Resident Debe;