HOW TO GET LATEST RECORD BASED ON TIMESTAMP

[#1]

Hi all

I have a requirement of fetching the Customer_ID with the latest time stamp, what ever being the ITEM he had purchased.

Header 1	Header 2	Header 3
ID	ITEM	TIME_STAMP
123	BOOKS	8/18/2015 13:11
123	PEN	8/18/2015 13:58
123	PENCIL	8/19/2015 15:55
999	PEN	7/17/2013 16:44
777	BOOKS	7/27/2015 19:25
777	PENCIL	7/29/2015 12:01
777	BOOKS	7/29/2015 12:01

I HAVE TO DISPLAY THE RECORD BASED ON LATEST TIMESTAMP IN A STRAIGHT TABLE.

please can any one help...!!!

Thanks in Advance

[MK_QSL]

Straight Table

Dimension

ID

Expression

1) Max(TIME_STAMP)

2) FirstSortedValue(ITEM,-TIME_STAMP)

[#3]

Hi Manish Kachhia

I have already tried that,any other way please check the output as below

if it has same time stamp it should pick up last value and it should not be blank.

[Digvijay_Singh]

Duplicate of getting the latest record based on time stamp

[maxgro]

if(max(TIME_STAMP)=max(TOTAL TIME_STAMP), max(TIME_STAMP))

t:

load ID, ITEM, Timestamp(Timestamp#(TIME_STAMP, 'MM/DD/YYYY hh:mm')) as TIME_STAMP

inline [

ID, ITEM, TIME_STAMP

123, BOOKS, 8/18/2015 13:11

123, PEN, 8/18/2015 13:58

123, PENCIL, 8/19/2015 15:55

999, PEN, 7/17/2013 16:44

777, BOOKS, 7/27/2015 19:25

777, PENCIL, 7/29/2015 12:01

777, BOOKS, 7/29/2015 12:01

];

[#6]

Hi Maxgro,

I agree what you meant but how do i get other customer Id

you have shown only ID 123 how about others. please can you check once

[MK_QSL]

FirstSortedValue(DISTINCT ITEM, -TIME_STAMP)

[#8]

Thanks

[maxgro]

if(max(TIME_STAMP)=max(TOTAL <ID> TIME_STAMP), max(TIME_STAMP))

[#10]

Hi Manish,

please can you look more in detail please, its not accepting DISTINCT and it says expression OK