5 Replies Latest reply: Oct 20, 2015 3:31 AM by Simone Spanio RSS

    Speed up Load

    clive ketley


      Hi All,

      I am currently trying to load a small table in Qlikview that extracts a created date from a large record set where the record ID exists in another table.

       

      The load statement I am using is below. The first record I want to extract starts after caseID 1597000 hence trying to put the greater than statement in. While the load works it takes over 2 hours to run. can anyone suggest a quicker way to perform the load. I have tried a mapped load and also a join but they also take a long time to run. For info the extract to date will be about 1000 records but will grow daily.

       

       

      if(caseID>1597000,caseID),

            
      Date(createdDateTime, 'DD/MM/YYYY') as createdDate

      where exists (caseID,caseID);

      SQL SELECT

          caseID,

          createdDateTime

          FROM myDatabase;

       

       

      Thanks for your help.