Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Script / UI ??
script only
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;
its still returns both projects for each agreement even though it should return only 1 for each agreement
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;