topic Re: Update Rows on Table in QlikView

Update Rows on Table

mariozubieta — Thu, 16 Nov 2017 20:14:11 GMT

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 — Thu, 16 Nov 2017 20:39:48 GMT

Load

from UpdateTable;

concatenate

Load

from QVDFile

where not exists(ID);

mariozubieta — Thu, 16 Nov 2017 20:45:15 GMT

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 — Thu, 16 Nov 2017 20:51:08 GMT

Load

ID,

Id as ExcludedID

from UpdateTable;

concatenate

Load

from ResidentQVDFile

where not exists(ExcludedID,ID);

Drop field ExcludedID;