Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Hi,
Have a look at the application attached for example.
Regards,
Kaushik Solanki !
HI
May be try like this
First 1 Load * from yourfilename where status = 'FinishedSuccess' Order by Timestamp desc;
Please attach the sample file
Hi Kaushik,
I am unable to open qvw, can you please send the script..
@SubbaReddy.
Hi Ramasamy,
I tried, but it was not getting. In timestamp field "T" is there. I hope may be that is the reason...
@SubbaReddy
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
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.
Hi
Post your sample data. So that, we can able to find the solution soon