Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Dayna,
see the attached example.
Maybe it gives an idea how you can get what you want.
Good luck!
Rainer
Hi,
Can u send the sample application/data?
Hello Manesh,
Please find attached.
Kind Regards,
Dayna
Hi Dayna,
Sorry, but i need more explanation to resolve ur problem.
can u explain me wit examples.
Thanks
Manesh
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
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_ServiceReqID
FROM
(
ooxml, embedded labels, table isSheet1);
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.
Hello Chakravarthy,
That looks like it's done the job! Many thanks!
Kind Regards,
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
Hi,
Dayna, please use the code which is send by me in application. It will work 100%.
Dayna,
Please refer the application attached.