Incremental Load for specific fileds only

ahmed_hassan — Tue, 04 Dec 2018 08:21:05 GMT

Dear all,

Just to be precise, I know how to use Incremental load from the general 3x cases:

Insert Only
Insert and Update
Insert, Update and Delete

I am interested in the 2nd case, therefore, I am using the following code:

Server:
LOAD ID, 
 Price, 
 Quantity,
 Date
FROM
[..\Files\SQL Server.xlsx]
(ooxml, embedded labels, table is Sheet1)

Where Date > '01.01.2018';

Concatenate(Server)
LOAD ID, 
 Price, 
 Quantity,
 Date
FROM
[..\QVDs\Server.qvd]
(qvd)

Where Not Exists(ID);

However, I am looking for a way to update specific fields only. In other words, How can I update the "Quantity" (based on the xlsx file), but keep the "Price" (based on QVD).

The only idea I have is to use a "left join" from a 2nd copy of the QVD (which will never be updated).

Any suggestion?

Thanks in advance 🙂

Re: Incremental Load for specific fileds only

tresB — Tue, 04 Dec 2018 08:37:32 GMT

Your idea is right. Additional join would be required in that case.

topic Incremental Load for specific fileds only in QlikView

Incremental Load for specific fileds only

Re: Incremental Load for specific fileds only