Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good morning,
i've got a table like this:
[price]:
load
YEAR,
PRICE,
ARTICLE
FROM ......;
I would like to load for every article the last price available.
How could i do it? With a max(year) function?
Thanks
Try this
[price]:
load
YEAR,
PRICE,
ARTICLE
FROM ......;
Final:
LOAD Max(YEAR) as YEAR,
PRICE,
ARTICLE
FROM ......;
Resident
price
Group by
PRICE,
ARTICLE
;
Drop table price;
i loaded those data but they don't work
[PR]:
LOAD * INLINE [
YEAR, PRICE, ART,
2020,10,DRT,
2021,20,DRT,
2020,30,VRT];
[PR2]:
LOAD
MAX(YEAR) AS YEAR,
PRICE,
ART
RESIDENT [PR] GROUP BY PRICE,ART;
DROP TABLE PR;
Could you please mention what is not working