Max value/Latest value of a dimension wrt max date

[Dataguy46]

Hi All,

I am trying the get a max value/ a latest value of a dimension with respect to its max date,

example data below

Expected output:

Lead ID	Process_date	LeadQA Status Name
524987	4/26/2019 9:13:45 AM	Delivered

[BrunPierre · Accepted solution]

In the script.

Data:
LOAD "Lead ID",
process_date,
"Lead QA Status Name",
...
FROM Source

Inner Join

LOAD Max(process_date) as process_date
Resident Data;

[BrunPierre · Accepted solution]

Grouping by Lead ID ensures that the Max(process_date) is aggregated for each Lead ID.

LOAD "Lead ID",
Max(process_date) as process_date
Resident Data
Group By "Lead ID";