Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I'm trying to load an excel file that has a column of rows that is wrongly formatted as hh:mm:ss but the actual format should be mm:ss.
So, for example i have a field that shows 07:22:00 but it should be 00:07:22.
When I try to load this file into QlikView I can't make it ignore this format.
If you open the csv-file in excel it will at first glance look like its correctly formatted but when you look in the expression field you will see the problem.
This is in reality a very large file that will be loaded daily so I really can't chenge anything in the csv-file, it has to be done in QV.
Will really appreciate any help with this.
change in your script.
time(time#(Servicing,'mm:ss'),'hh:mm:ss') as Servicing
Hope that helps you.
change in your script.
time(time#(Servicing,'mm:ss'),'hh:mm:ss') as Servicing
Hope that helps you.
Thank you so much for your help, it works great!!!