topic Re: Delete current month records in incremental load in QlikView

Delete current month records in incremental load

Anonymous — Tue, 17 Nov 2015 11:23:45 GMT

Hi,

I am doing incremental load and I want to delete current month data in that load. I have to do it where clause, but how to include that condition where clause before doing STORE command. Please give me suggestions.

Regards,

Kumar

Re: Delete current month records in incremental load

avinashelite — Tue, 17 Nov 2015 11:29:25 GMT

you need to update the condition in the main table you cannot have a where clause in the store statement

Try like this :

Incrimental_table:

LOAD *

where month<>currentmonth;

SQL

incrimental statements ;

create a resident table with table with the where clause and use the same in the store statement

Re: Delete current month records in incremental load

Anonymous — Tue, 17 Nov 2015 11:31:04 GMT

can we do sth like:

load

Date,

Restofdata

from YourTable where num(month(Date))<>(Not Equal to)num(Month(Today()))

Re: Delete current month records in incremental load

Anonymous — Tue, 17 Nov 2015 11:40:58 GMT

Thanks for your reply. Here date is coming from column DW_load_date. So CAn you tellme how do i include this month here.

Regards,

Kumar

Re: Delete current month records in incremental load

Anonymous — Tue, 17 Nov 2015 11:50:01 GMT

replace Date with DW_load_date

Re: Delete current month records in incremental load

Anonymous — Tue, 17 Nov 2015 11:52:12 GMT

just editing it:

use this:

load

date(Date,'DD/MMM/YYYY') as Date,

Restofdata

from YourTable where num(month(Date))<>(Not Equal to)num(Month(date(Today(),'DD/MMM/YYYY')))

Re: Delete current month records in incremental load

Anonymous — Tue, 17 Nov 2015 11:52:37 GMT

If my data is not today, then it will give me wrong results?

Re: Delete current month records in incremental load

Anonymous — Tue, 17 Nov 2015 11:55:05 GMT

Today only or not have for full today month??

if today only, no worry.

But if you are not having data of November, you would not be able to check whether its working or not

Re: Delete current month records in incremental load

pljsoftware — Tue, 17 Nov 2015 16:29:19 GMT

Hi Kumar,

if would you like to make easy your job you can use the library RobWunderlich/Qlikview-Components · GitHub that contains all you need to do better incremental load.

I you want to delete record from a table you have to use inner join with a temp table where exists some fields with value that you that to mantain.

Best Regards

Luca Jonathan Panetta