2 Replies Latest reply: Mar 19, 2013 6:57 AM by Daniel Sturesson RSS

    Ignore time formatting when loading file

      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.