topic Re: Timestamp convertion in QlikView

Timestamp convertion

Tue, 01 Mar 2016 02:45:01 GMT

Hi,

Any one can help me to convert the below timestamp..

--> 20160223T050024.225-0800

Tue, 01 Mar 2016 02:53:41 GMT

You can try like below:

Timestamp#(Replace(subfield(text(timestampfield),'.',1),'T',' '),'YYYYMMDD hhmmss')

Tue, 01 Mar 2016 03:17:43 GMT

Hi,

Its getting the value.. But i need help with the below attachment to show only latest record based on region...

Sub2u444

Tue, 01 Mar 2016 03:22:21 GMT

Try like below:

Source:

LOAD

Timestamp(Timestamp#(Replace(subfield(text(timestampfield),'.',1),'T',' '),'YYYYMMDD hhmmss')) as new_ts

From file;

Inner Join,

Load

TaskName,

Timestamp(Max(new_ts)) as new_ts

Resident Source

Group by TaskName

;

settu_periasamy — Tue, 01 Mar 2016 03:31:26 GMT

Check here also..

Digvijay_Singh — Tue, 01 Mar 2016 04:44:14 GMT

See if attached can help -

Load *,

num#(Timestamp#(Date + Time)) as FinalTimestamp;

Load *,

Date(date#(SubField(Timestamp,'T',1),'YYYYMMDD'),'DDMMYYYY') as Date,

maketime(Mid(Timestamp,10,2),Mid(Timestamp,12,2),Mid(Timestamp,14,6)) as Time;

Load * inline [

Timestamp, Region

20160223T090024.495-0800, Japan

20160223T110023.494-0800, Japan

20160223T130026.273-0800, Japan

20160223T150028.306-0800, Japan

];