Qlik Community

QlikView Documents

QlikView documentation and resources.

Announcements
Document boards are being consolidated, this board no longer allows NEW documents READ MORE

CRUDhelper framework - Incremental loads with ease

cancel
Showing results for 
Search instead for 
Did you mean: 
rverschuren
Contributor II
Contributor II

CRUDhelper framework - Incremental loads with ease

Attachments

With the help of the CRUDhelper framework you can keep your QVD files in shape.

You can perform Create, Read, Update and Delete (CRUD) actions with ease.

Incremental loads (and of course full loads) will become very easy now.

All CRUD actions are time stamped and affected rows will be counted.

This way you can monitor your ETL-process in great detail.

The metadata is saved in a batch control file.

This file also contains the parameters for the next incremental load.

The CRUDhelper helps you with:

  • Backing up the old QVD file.
  • Counting the number of valid rows in the source.
  • Reading the (new or updated) source data.
  • Creating new rows and updating existing rows.
  • Deleting invalid rows.
  • Rebuilding the data if an incremental load fails.
  • Storing the data to the QVD file.

In this document you will find the QVW file and a PDF file.

The PDF file will get you started in minutes.

If you have ideas, questions or remarks please let me know.

Best regards,

René Verschuren

Comments
gilbertomedeiro
Contributor III
Contributor III

Hi René

thanks for sharing your background in QV good practices! That's great! It's very useful, at least to me!

Thanks,

Gilberto

0 Likes
Version history
Last update:
‎2013-11-15 06:41 AM
Updated by: