11 Replies Latest reply: Sep 6, 2013 1:22 PM by joão lopes RSS

    Filter data during Load

    james.w.mccarthy

      I am loading a small (50K) excel sheet and a large (2M) oracle table, I would like to only load the data in the oracle table that is common to both datasets thus reducing the load time. I know I could do this outside of Qlikview, just wondered if I was missing some option/script tip to do this?

      Also, is a 2million row, 100 column considered big for qlikview to manage? Uusually I am looking at a good 3-4 hours to load this - any tips to improve performance or only load changes to the table not a full refresh each time?

       

      Thanks in advance