This content has been marked as final. Show 2 replies
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.