5 Replies Latest reply: Dec 18, 2014 10:33 AM by mario Gergy-sarkis RSS

    Reading from Excel sheet

    mario Gergy-sarkis

      hi All

      please I need your help

       

      i am reading on Qlikview from an Excel Sheet but i am facing a problem.

      how can i fill an empty Cell  ex:

        A              B               C

      Jul-14
      AvgIntRate
      12233251
      321222133
      123131131

       

      When i Importing this Form the first cell in column B and C is empty

      the script will show like this

      Directory;

      Load

      41650,

      F2,

      F3,

       

      i need to show as

      41650,    

      41650,

      41650

       

      Ps: i cannot change in the form of the excel sheet cause i have almost a hundred excel sheet same form so if i change one i have to change the others so it will take alot of time, i am looking for a solution using Qlikview,

       

      Thank you.