How to show last update for each record...?

[Dayna]

Dear all,

I hope that you can help me, I'm trying to show in a chart the last entry (i.e. last update) for each record..

i.e. ID1 has 6 updates, I want to show the last. ID2 has 1 update, show the last (and first), ID3 has 4 updates (show the last). But I need to show this for each record, not the last overall.

I hope that you can help me!!

Kind Regards,
Dayna

[maneshkhottcpl]

Hi,

Can u send the sample application/data?

[Dayna]

Hello Manesh,

Please find attached.

Kind Regards,
Dayna

[maneshkhottcpl]

Hi Dayna,

Sorry, but i need more explanation to resolve ur problem.

can u explain me wit examples.

Thanks

Manesh

[Dayna]

Hello Manesh,

To base on the excel sheet, what I would like to show is for each SUN_ServiceReqID the last update performed. So, for the entry INC000048 the last update date/time would be 18/11/2010 13:59:16. What I'm trying to show, is the last update date/time for each ServiceReqID. So then I'd have an overview:

INC000048 - 18/11/2010 13:59:16
INC000049 - 06/12/2010 11:29:11
INC000050 - 09/12/2010 09:08:38 etc etc...

Hope this clarifies it a bit more.

Kind Regards,
Dayna

[#6]

Hi Dyna ,

Hope this will help you ..

LOAD

Max

(Time(SUN_IH_Update)) as Time

,

Max

(Date(SUN_IH_Update)) as SUN_IH_Update

,

SUN_ServiceReqID

FROM

(

ooxml, embedded labels, table is Sheet1) group by SUN_ServiceReqID

;

left

join

LOAD

SUN_IH_AddedBy

,

SUN_ServiceReqID

FROM

(

ooxml, embedded labels, table is

Sheet1);

If you have only one record that will be the max record . You will get that record using the above logic .If you want to dsiplay it as a single field just concatenate the both.

Regards,

Chakravarthy.

[Dayna]

Hello Chakravarthy,

That looks like it's done the job! Many thanks!

Kind Regards,
Dayna

[Dayna]

Ahh... Now that all the data is there, it doesn't seem to work anymore.. I get multiple entries for each AddedBy User... Any ideas? You're help is most appreciated!

Kind Regards,
Dayna

[maneshkhottcpl]

Hi,

Dayna, please use the code which is send by me in application. It will work 100%.

[maneshkhottcpl]

Dayna,

Please refer the application attached.