price analysis

[Carlaf_93]

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

[avinashelite]

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;

[Carlaf_93]

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;

[avinashelite]

Could you please mention what is not working 

[Carlaf_93]