Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

News and modified rows STORING

Hi,

I have a table like this (using QVD STORE if neccessary):

LOCATAFOLLETOPRIMER_SERVICIOPAXESORIGEN
130000011FV1PU22/08/20112MAD
1300002295A03012/09/20112OVD
130000230FV1PU03/09/20112MAD
130000776FI0RM05/11/20102MAD

Every day I receive a new table with new and modified rows like, for example this:

LOCATAFOLLETOPRIMER_SERVICIOPAXESORIGEN
1300002295A03022/09/20112OVD
130000235FV1PU03/09/20112MAD

I would like to know how to update the first table with the data in the second table, by LOCATA.

So it should result like this:

LOCATAFOLLETOPRIMER_SERVICIOPAXESORIGEN
130000011FV1PU22/08/20112MAD
1300002295A03022/09/20112OVD
130000230FV1PU03/09/20112MAD
130000776FI0RM05/11/20102MAD
130000235FV1PU03/09/20112MAD

Remaining the LOCATA 130000011, 130000230, 130000776 as they were, changing locata 13000229 in its PRIMER_SERVICIO date and adding LOCATA 130000235 as a new row.

Thanks

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Please have a look into the QV cookbook, in particular into the  Incremental Load sample:

http://robwunderlich.com/downloads/

It explains quite well how to do an incremental load while taking care of updated, deleted, new records.

View solution in original post

1 Reply
swuehl
MVP
MVP

Please have a look into the QV cookbook, in particular into the  Incremental Load sample:

http://robwunderlich.com/downloads/

It explains quite well how to do an incremental load while taking care of updated, deleted, new records.