Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community
Please find the attached QVW file and advice on how i can format my time field .
e.g
253 to 00:02:53
20904 to 02:09:04
Regards
Mutshidzi
Try something like this:
LOAD
WI_CT as [Creation Time],
Interval(Interval#(Num(WI_CT, '000000'), 'hhmmss'), 'hh:mm:ss') as NewCreationTime
FROM
(ooxml, embedded labels, table is Multi0103);
Try something like this:
LOAD
WI_CT as [Creation Time],
Interval(Interval#(Num(WI_CT, '000000'), 'hhmmss'), 'hh:mm:ss') as NewCreationTime
FROM
(ooxml, embedded labels, table is Multi0103);