topic Re: Conditional Delete for Incremental Load in QlikView

Conditional Delete for Incremental Load

Fri, 07 Feb 2014 10:46:12 GMT

Hello all,

Is it possible to pass a month parameter for the Delete task in Incremental Load?

In other words, My delete task in Incremental load should look up for only past 6 months data and delete the files which are already deleted from datasource.

Any Help would be appreciated.

Best Regards,

Susvith

Re: Conditional Delete for Incremental Load

luis_pimentel — Fri, 07 Feb 2014 11:25:04 GMT

Hi,

Did you check out this document Incremental Load.docx about how to implement Incremental Loads?

Hope that helps!

-Luis.

Re: Conditional Delete for Incremental Load

Mon, 10 Feb 2014 07:06:28 GMT

Thanks for your reply Luis

I am done with Incremental load (Insert/Update/Delete). Now I got scenario , that while deleting its should check only last 6 months data instead of whole data.

Is it something possible??

Thanks in advance

Re: Conditional Delete for Incremental Load

jonathandienst — Mon, 10 Feb 2014 07:23:13 GMT

You cannot delete loaded data. For this scenario, just load data that is less than 6 months when loading from the previously extracted data from QVD(s).

FactTable:

LOAD *

From MyData.qvd

Where TransactionDate > AddMonths(Today(), -6);

Concatenate (FactTable)

HTH

Jonathan

Re: Conditional Delete for Incremental Load

Mon, 10 Feb 2014 10:38:02 GMT

Thanks for your reply jonathan