loading max time of a date

[#1]

Hi all,

Any help is much appreciated on the following:

I have the following dates:

I only want to load the most recent time of each date. ie:

As this has been edited most recently

I can't seem to get the max function to work here.

Thanks,

[PrashantSangle]

Hi,

USe max(Date(Date#(DateField,'DD.MM.YYYY hh:mm')))

Regards

[alexandros17 · Accepted solution]

To do this use the following logic:

Tab1:

Load a,b,c resident mytab; // The field c is the one for which you need the max for each a value

left join

Load a, max(c) as maxValPerKey resident Tab1 Group by a;

Let me know

[swuehl]

Maybe something like

DATA:

LOAD

     TimestampField,

     ...

FROM ...;

INNER JOIN LOAD

     Timestamp(max(TimestampField)) as TimestampField

RESIDENT DATA

GROUP BY Daystart(TimestampField);