Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
yashdeep
Contributor III
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
bill_markham

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
Contributor III
Contributor III
Author

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

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
Contributor III
Contributor III

Hi,

Maybe this wolud help..

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

Regards,

Bhavini S Mehta.

vikasmahajan
Champion
Champion

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

Please check it with

Vikas