topic Re: Max value/Latest value of a dimension wrt max date in App Development

Max value/Latest value of a dimension wrt max date

Dataguy46 — Tue, 30 Apr 2024 09:22:28 GMT

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 — Tue, 30 Apr 2024 09:58:31 GMT

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 — Fri, 03 May 2024 08:31:41 GMT

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";