Get last date for each record

[Eaun]

I want to get get the last date for each part number received into seperate field in the load scripTt what is the best way to go about this ?

[Vegar]

Load *
From
EXCEL.xlsx (...);

Left join
Load
part,
Max(date) as maxdate
From EXCEL.xlsx (...)
Group by part;

[Eaun]

Thanks for that but what if I wanted to just have the max date for that part only with the qty ?

How would I do that ?

[Vegar · Accepted solution]

You could do as in script below. First pick out the max date per part and then join in the qty for that date. 

Data:
Load
   part,
   Max(date) as date
From 
   EXCEL.xlsx (...)
Group by 
   part
;

LEFT JOIN (Data)
LOAD 
   part, 
   date, 
   qty
FROM Excel.xlsx (...);