chose values by max date according to 2 fields

[anatle1234]

hi ,

I have this example:

I am not able to create max approval column. for each agreement I need to put there approval with lastest date.

I need to do it in the script for my main table, to add this column for each agreement.

can you please help.

thanks,

Anat

[Anil_Babu_Samineni]

Script / UI ??

[anatle1234]

script only

[Anil_Babu_Samineni]

Not tested, But can u try this?

If(agreement = Previous(agreement), approval,'') as [max approval]

OR

Table:

Load * from table;

Final:

NoConcatenate

LOAD approval, agreement, date, If(agreement = Previous(agreement), approval,'') as [max approval] Resident Table Order By date desc;

DROP Table Table;

[anatle1234]

its still returns both projects for each agreement even though it should return only 1 for each agreement

[Anil_Babu_Samineni]

Oh, Is it? Then this should work

Table:

Load * from table;

Right Join (Table)

LOAD agreement, Max(date) as date Resident Table Group By agreement;

Left Join (Table)

Load agreement,FirstSortedValue(approval, date) as [max approval] Resident Table Group By agreement;