Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table like this (using QVD STORE if neccessary):
LOCATA | FOLLETO | PRIMER_SERVICIO | PAXES | ORIGEN |
130000011 | FV1PU | 22/08/2011 | 2 | MAD |
130000229 | 5A030 | 12/09/2011 | 2 | OVD |
130000230 | FV1PU | 03/09/2011 | 2 | MAD |
130000776 | FI0RM | 05/11/2010 | 2 | MAD |
Every day I receive a new table with new and modified rows like, for example this:
LOCATA | FOLLETO | PRIMER_SERVICIO | PAXES | ORIGEN |
130000229 | 5A030 | 22/09/2011 | 2 | OVD |
130000235 | FV1PU | 03/09/2011 | 2 | MAD |
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:
LOCATA | FOLLETO | PRIMER_SERVICIO | PAXES | ORIGEN |
130000011 | FV1PU | 22/08/2011 | 2 | MAD |
130000229 | 5A030 | 22/09/2011 | 2 | OVD |
130000230 | FV1PU | 03/09/2011 | 2 | MAD |
130000776 | FI0RM | 05/11/2010 | 2 | MAD |
130000235 | FV1PU | 03/09/2011 | 2 | MAD |
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
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.
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.