Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
yashdeep
New Contributor III

Check whether there is any modification in data in Incremental Load

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.

5 Replies

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

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.
yashdeep
New Contributor III

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

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" .

Not applicable

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

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

bhavinimehta
New Contributor III

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

Hi,

Maybe this wolud help..

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

Regards,

Bhavini S Mehta.

vikasmahajan
Honored Contributor III

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

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

Please check it with

Vikas

Community Browser