Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Load
ID,
Id as ExcludedID
from UpdateTable;
concatenate
Load
*
from ResidentQVDFile
where not exists(ExcludedID,ID);
Drop field ExcludedID;
Load
ID
from UpdateTable;
concatenate
Load
*
from QVDFile
where not exists(ID);
is there a way to do it with the qvd loaded previously, without having to store it and load it.
thanks for the reponse.
Load
ID,
Id as ExcludedID
from UpdateTable;
concatenate
Load
*
from ResidentQVDFile
where not exists(ExcludedID,ID);
Drop field ExcludedID;