Re: SET Flag on Oldest Price in price changes table
The function is called Last Value.
This is how it is described in the help menu.
Returns the last value in load order of expression over a number of records as defined by a group by clause. If no text value is found, NULL is returned. This function is only available as a script function.
Load City, LastValue(Name), as FirstName from abc.csv group by City;