topic Add new and modified data on table in QlikView

Add new and modified data on table

Fri, 09 Apr 2010 15:19:48 GMT

Dear all,

I have a problem and I don't know how to solve it.

I have an historical table with a lot of data.

I want to update records and insert new ones.

Historical's database is on qvd file.

My question is to know how to update historical table with new update records.

I don't want to load new table as first one, and then, load my historical with 'where not exists' clause.

Steps that I want.

1. Load historical table

2. Append new ones

3. Update old with the new values.

Best regards

Fri, 09 Apr 2010 16:01:15 GMT

Have you thought about creating a qlikview app to pull in your historical data.

table(new data)

Load historicaldata

join

new data

store newdata into newdatafile.qvd

Now you have new data added onto your historical data without editing the historical data qvd

Fri, 09 Apr 2010 16:23:44 GMT

Hello,

I want to update historical table with new ones and update old ones that have any changes.

Add new ones is easy, bacause KEY doesn't exist, but....

How to update records that have diferences between historical and the new file.

Best regards