topic Re: Only current month records update in QlikView

Only current month records update

Anonymous — Thu, 10 Dec 2015 11:06:53 GMT

Hello Everybody

In a daily load I want to update records only in current month records and it should not update previous month records. Here we don't have any date column and we have only key column is there.

we can do update without date column also. But I need current month records only should be affected in load.

Please give me any ideas.

Regards,

Reddy

Re: Only current month records update

sunny_talwar — Thu, 10 Dec 2015 11:09:55 GMT

If you don't have date, how would you even know if a particular row is for this month or last month?

Re: Only current month records update

Anonymous — Thu, 10 Dec 2015 11:15:49 GMT

Agrred with Sunny.

Check these threads, may help you..

Incremental Load without Date field

Incremental Load without Updated Date and Time

Incremental load without date in Database

http://www.learnqlickview.com/a-qlikview-qvd-function-to-simplify-incremental-data-load/

Re: Only current month records update

Anonymous — Thu, 10 Dec 2015 11:16:13 GMT

I mean date column in the sense, I have like mm-yyyy column is there. Not like dd/mm/yyyy.

Re: Only current month records update

sunny_talwar — Thu, 10 Dec 2015 11:21:47 GMT

Oh okay, then you should be able to do something like this:

Step 1) Load the new data for just the current month using the date field you have.

Step 2) Load your complete data, but use a where not exist statement to remove all the ids which are present in your new incremental data. (so remove the last one month worth of ids)

Step 3) Concatenate the new incremental data (Table in Step 1) to your existing data (Table in Step 2)

Re: Only current month records update

Anonymous — Thu, 10 Dec 2015 11:40:20 GMT

Hi Sunny,

Thanks for your reply.

If you don't mind, can you give me outline code.

Regards,

Kumar

Re: Only current month records update

sunny_talwar — Thu, 10 Dec 2015 12:26:39 GMT

Try something like this:

NewData:

LOAD A,

Date,

ID as ID_Check

FROM Source

Where Num(Date) >= Num(MonthStart(Today()));

Data:

LOAD A,

Date,

FROM someqvd.qvd (qvd)

Where not Exists(ID_Check, ID);

Concatenate(NewData)

LOAD A,

Date,

ID_Check as ID

Resident Data;

DROP Table NewData;