How to get the values which contains oldest date?

[#1]

Hi,

I have a table box which gets data from excel file. The columns are

For e.g.:

ID               Summary        Date

442542       5months         23/09/2008

442542       5months         02/01/2012

How can I get the table box which contains only the values with oldest date. I,e

ID               Summary        Date

442542       5months         23/09/2008

Thanks.

[MK_QSL · Accepted solution]

Min(Date)

UPDATE :

SCRIPT

Temp:

Load * Inline

[

  ID,               Summary,        Date

  442542,       5months,         23/09/2008

  442542,       5months,         02/01/2012

];

Load

  FirstSortedValue(ID, Date) as ID1,

  FirstSortedValue(Summary, Date) as Summary1,

  FirstSortedValue(Date, Date) as Date1

Resident Temp;

Now create a table box with dimensions

ID1, Summary1 and Date1

[#3]

Thanks Manish. How can I give this in table box?

[MK_QSL]

replied as an update

[#5]

That's super working!  Thanks.