Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
samuel_brierley
Creator
Creator

loading two time formats

Hi all,

I have a strange problem and quite simply no idea how to deal with this,

my log files contain data for every half second which provides two time formats e.g

57601.5
57602

(time#(Timestamp,'ss:f'),'hh:mm:ss:f') as Timestamp,

(time#(Timestamp,'ss'),'hh:mm:ss') as Timestamp,

I can solve each of the formatting errors seperatly using one of the above lines but cant figure out how to solve both at the same time.

I presume the script must read something like;

"if format is A do X, if NOT do y"

but the above is a little beyond me.

any help would be greatly appreciated. thanks

1 Solution

Accepted Solutions
MarcoWedel

Time(Time#(Timestamp,'ss[.f]'),'hh:mm:ss:f') as Time

View solution in original post

3 Replies
MarcoWedel

Time(Time#(Timestamp,'ss[.f]'),'hh:mm:ss:f') as Time

samuel_brierley
Creator
Creator
Author

Brill thanks

MarcoWedel

You're welcome

regards

Marco