How to get a maximum value with a key field.

[Anonymous]

Hi guys,

How can I get the maximum from a duplicated key in load script.

Example:

S/N	Date
1	10/10/2015
1	20/10/2015
2	15/10/2015
2	30/10/2015

In this case I would like to see the table below:

S/N	Date
1	20/10/2015
2	30/10/2015

Is there a way of doing that?

Thanks in advance.

[Gysbert_Wassenaar · Accepted solution]

Use S/N as dimension and Max(Date) as expression

[sunny_talwar]

I would just use Date(Max(Date)) as expression to get a date field instead of number

[Chanty4u]

try,

load *,

......

max(Date)  

from table    where [sn]=1  and  [sn]=2;

[Kushal_Chawda]

Data:

LOAD [S/N],

          date(max(Date)) as Date

FROM Table

Group By [S/N]

[Kushal_Chawda]

Yes, that you can format it from Number Tab of Table

[sunny_talwar]

Why take some extra steps. My fingers hurt when I do that