max(Load Date) function

[#1]

Hi all,

Can anyone answer how can I load the latest loaded(4/20) record i.e C.

Here among the three dates most recent date is 4/20. so I need to load the corresponding Val i.e.C using the group by function on year and No.But I am not sure what function/expression needs to be used to find out the latested load_dt.

Year No. load_dt Val

2011 1 2/20 A

2011 1 3/20 B

2011 1 4/20 C

Thanks,Pooja

[#2]

pooja,

Load Year,

No,

Date,

Value

from xxx where Date='04/20';

or Create a variable for to get maximum date value and use that,

e.g load *

from xxx where Date='$(v_MaxDate)';

where v_MaxDate= Maximum of Date

Regards,

Dixit

[erichshiino]

Hi, Pooja

I used group by to get the max load date for each number by year and I set some flags that you can use in the script (to eliminate old results) or you can use at the interface on tables or set analysis.

I hope it helps

[#4]

thanks Erich.it's working fine.