Check whether there is any modification in data in Incremental Load

[yashdeep]

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.

[Anonymous]

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]

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

[#4]

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

[Anonymous]

Hi,

Maybe this wolud help..

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

Regards,

Bhavini S Mehta.

[vikasmahajan]

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

Please check it with

Vikas