Qlik Community

QlikView Documents

QlikView documentation and resources.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING

QlikView Expressor Incremental Load Examples

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QlikView Expressor Incremental Load Examples

This QlikView Expressor sample workspace provides some examples of dataflows that support incremental loading of QlikView data.  The following dataflows are included in the sample project:

  • AdditionsOnly_Funnel:  A dataflow that handles augmenting an historical data set with newly arriving data.  This case is useful with append-only data whose records are never updated or deleted (e.g. machine generated data like web logs).
  • AdditionsOnly_Append:  A variation of AdditionsOnly_Funnel that uses the Write QlikView operator’s “append” property to append data to the end of a previously existing QlikView data file (QVD or QVX).
  • AdditionsAndUpdates: A dataflow that handles merging new and changed records from a change record stream into an historical record set to bring the historical record set up-to-date.
  • AdditionsUpdatesAndDeletes: An incremental load dataflow that handles additions, modifications and deletions of records.
  • GenerateDataUsingFlow:  A dataflow that generates a few years’ worth of data to test the dataflows above.
  • Moving36MonthWindow:  A dataflow that processes the handles a moving, 36-month data history window by dynamically selecting which historical files to read and merging in the new records from the current day and prior days of the current month.
  • Generate36MonthInvoiceHistory:  A dataflow that generates 36 months’ worth of data to test the Moving36MonthWindow  dataflow.
Attachments
Version history
Last update:
‎2014-04-08 09:27 AM
Updated by: