I have a matrix which looks like this:
In the "Data load editor" I added the following
The result for the Date is correct, but unfortunately the time is wrong. It should be 08:19:58 (hh:mm:ss)
Can someone please help.
Try this (use single h instead of 2)
Time(Time#(TPROA, 'hmmss')) as [Time-scan-return-carton]
unfortunately scan time can be
81920 = 08:19:20 as well as
182130 = 19:21:30 (which are now not shown correctly)
I think sunil might have meant this...
Time(Time#(TPROA, If(Len(Trim(TPROA)) = 5, 'hmmss', 'hhmmss'))) as [Time-scan-return-carton];
LOAD * Inline [
The above seems to work
can you try this
Time(Time#(If(len(TPROA)>5, 'hhmmss','hmmss'))) as [Time-scan-return-carton]
please share sample
I like your approach, but it didn't work.
here is the sample
Did you try this?
Try this, it should work
Retrieving data ...