incremental load custom where clause

RobWunderlich / Qlikview-Components

A library for common Qlikview Scripting tasks

197 stars 99 forks source link

incremental load custom where clause #30

Open domski74 opened 9 years ago

domski74 commented 9 years ago

In order to always retain only a specific period (e.g. 2 years) worth of data in the imcremental qvd, I'd like to suggest that you have the ability to add a from date to the qvc incremental load so the qvd concatenate adds a where clause. Added as an optional parameter in incrementalstore?

Thanks

MattFryer commented 9 years ago

Hi, Interesting idea! Having taken a look I can't see any obvious work around but Rob knows the incremental routines better than myself so he might be able to suggest one. We could possibly use the existing Qvc.Loader.v.BaseValue variable to implement this which is normally only used when performing the first reload or when a full reload has been requested.

Regards Matt

MrCode9 commented 7 years ago

Hi Matt, to cut off the "n" days in QVD, just create temporary table that had all date values with in "n" range and Inner join with your QVD table. The down side is we need to add new field "date" if we don't have a date field (timestamp field).