Update Rows on Table

[mariozubieta]

Hello,

I'm currently trying to load information from a file, and replace the updated values on my qvd. For example:

Any ones has ideas on how to do this. Both current qvd and update table fields are named the same.

thanks

[Anonymous]

Load

ID

from UpdateTable;

concatenate

Load

*

from QVDFile

where not exists(ID);

[mariozubieta]

is there a way to do it with the qvd loaded previously, without having to store it and load it.

thanks for the reponse.

[Anonymous · Accepted solution]

Load

ID,

Id as ExcludedID

from UpdateTable;

concatenate

Load

*

from ResidentQVDFile

where not exists(ExcludedID,ID);

Drop field ExcludedID;