1 Reply Latest reply: Jun 3, 2010 4:10 PM by John Witherspoon RSS

    Delta extraction based on "High Water" fields

    jhawk95337

      Hello all,

      I'm new to QlikView, using QlikView with SAP and SAP BW. We have a large amount of data, and need to performe incremental loads.

      In performing QlikView extractions, can QlikView perform a delta or incremental extact using a field like a document number or timestamp as 'high water mark' - storing the maximum value from the previous extraction, and using 'greater than' logic to select records greater than the last extraction's highest value.

      High water mark, delta, or incremental extraction have been standard features in ETL tools for 15 years, but I can not find information on how to do this in QlikView!

      Please send hyperlinks and sample code!

      Thanks,

      John Hawk