topic Re: Get last date for each record in App Development

Get last date for each record

Eaun — Mon, 20 May 2019 13:26:34 GMT

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 — Mon, 20 May 2019 13:46:42 GMT

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

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

Eaun — Mon, 20 May 2019 14:59:05 GMT

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 — Mon, 20 May 2019 19:21:38 GMT

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 (...);