Find LogFile latest data

[#1]

Hi Folks,

i am going to create a dash board with log files, but in the below image it was showing 5 records for Japan.

How to find the latest one, can you help some one..

@Sub2u

[kaushiknsolanki]

Hi You can create a new field called time stamp from one of your field like below.

Load *,

Timestamp(Date(Date#(left(Timestamp,8),'YYYYMMDD')) + Time(Time#(Mid(Timestamp,10,6),'hhmmss'))) as New_Stamp

From xyz.

Then as this in your chart and sort on this field.

Regards,

Kaushik Solanki

[#3]

Hi Kaushik,

Thanks for the reply.

I applied the above code, but it was not showing any data. In that timestamp "T" is there.

Please help...

@SubbaReddy

[kaushiknsolanki]

Hi,

Have a look at the application attached for example.

Regards,

Kaushik Solanki !

[MayilVahanan]

HI

May be try like this

First 1 Load * from yourfilename where status = 'FinishedSuccess' Order by Timestamp desc;

Please attach the sample file

[#6]

Hi Kaushik,

I am unable to open qvw, can you please send the script..

@SubbaReddy.

[#7]

Hi Ramasamy,

I tried, but it was not getting. In timestamp field "T" is there. I hope may be that is the reason...

@SubbaReddy

[kaushiknsolanki]

LOad *,Timestamp(Date(Date#(left(Timestamp,8),'YYYYMMDD')) + Time(Time#(Mid(Timestamp,10,6),'hhmmss')))  as New_Stamp

inline [

Timestamp

20160223T090024.495-0800

];

Regards,

Kaushik Solanki

[#9]

Hi,

New_Stamp getting blank '-'. I hope its for only one i guess.

when i checked for one it was showing the datetime value.

Thank You..

still in stuck to get the latest record...

@SubbaReddy.

[MayilVahanan]

Hi

Post your sample data. So that, we can able to find the solution soon