Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER

Bringing uniform timestamp

Master II
Master II

Bringing uniform timestamp

Hi All,

How to bring to uniform time stamp if we have different timestamps from the same field?

Here is the solution.

Data:

LOAD *,TimeStamp(

   Alt(

      TimeStamp#(Date_Value,'YYYY-MM-DD hh:mm'),

      TimeStamp#(Date_Value,'M/D/YY h:mm')

      ),

      'YYYY-MM-DD hh:mm'

   ) as New_Date_Value;

Load * inline [

Date_Value

2001-12-06 23:00

2001-12-06 23:12

2001-12-06 23:22

2001-12-06 23:38

2001-12-06 23:39

1/13/06 0:00

1/13/06 0:00

1/13/06 0:01

1/13/06 0:01

1/13/06 0:01

1/13/06 0:01

1/13/06 0:09

1/13/06 0:28

1/13/06 1:12

1/13/06 1:12

1/13/06 1:30

];

Capture.JPG

Attachments
Comments
Creator III
Creator III

Good stuff! not happening that often in my experience, but it's worth knowing this small trick of yours!

Version history
Revision #:
1 of 1
Last update:
‎2015-09-03 09:46 PM
Updated by: