topic Re: Check whether there is any modification in data in Incremental Load in QlikView

Check whether there is any modification in data in Incremental Load

yashdeep — Thu, 17 Dec 2015 09:59:02 GMT

Hi All,

I am getting one .txt file every day which I have to Concatenate to the existing qvd File.

The file coming every day may have old records.

I am using incremental load for This and using "not exists()" to avoid duplicate values.

There is no Modified date field in The table.

but

this will simply load the new data and not old one.

What I want is if there is any change in Field "Leaving Date" of Same Emp ID It should capture it.

Primary Key = Emp ID.

Field to check for modification = "Leaving Date".

Thanks in advance.

Re: Check whether there is any modification in data in Incremental Load

Anonymous — Thu, 17 Dec 2015 19:00:57 GMT

Load the first file, store as a qvd and exit script from your qvw.

Load the next file. then concatenate on the stored qvd with your where not exists() , store this as the same qvd name [it will overwrite the old qvd file]

Repeat as your new daily files appear.

Re: Check whether there is any modification in data in Incremental Load

yashdeep — Fri, 18 Dec 2015 04:19:54 GMT

Thanks for the reply Bill,

But my main problem is that if there is any modification corresponding to a Emp Id which is already

Present in the Old Qvd Then it will simply replace the old value whereas i want to create a flag that

some modification has been done.

I just want to capture the modification in"Leaving date " field .

If the Leaving date in new file is not equal to Leaving date

in stored qvd of the same Emp ID the Value of the flag should be= "Modified" .

Re: Check whether there is any modification in data in Incremental Load

Fri, 18 Dec 2015 05:22:19 GMT

store your existed file into qvd.

once you get the new file concatenate that with the old Qvd and store that with the Old qvd name and use not exists()

what bill said already.

so your new data will concatenate with old data and there wont be any duplication and you will get the modified data.

Regards,

Sowmya

Re: Check whether there is any modification in data in Incremental Load

Anonymous — Fri, 18 Dec 2015 05:41:39 GMT

Hi,

Maybe this wolud help..

http://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/‌

Regards,

Bhavini S Mehta.

Re: Check whether there is any modification in data in Incremental Load

vikasmahajan — Fri, 18 Dec 2015 06:55:13 GMT

I think solution is here http://www.tutorialspoint.com/qlikview/qlikview_incremental_load.htm

Please check it with

Vikas