get max date from qvd

[#1]

Hi,

I want to pull from  QVD only the max date of each product.

How can I do that? see example below.

Raw Data:

PART  PRICE    DATE

a          10          01/01/2014

a          20          01/01/2015

b          10          01/01/2015

Output:

a          20          01/01/2015

b          10          01/01/2015

Thanks to all,

Jacob

[#2]

Brilliant

[anbu1984]

Firstsortedvalue(Date,-Date) -- Due to minus on Date, you will get highest value

Check this ex

Load Part,Firstsortedvalue(Date,-Date) as Date,Firstsortedvalue(Price,-Date) as Price Group by Part;

Load * Inline [

Part,Price,Date

a,10,01/01/2014

a,20,01/01/2015

b,10,01/01/2015 ];