Incremental Load for specific fileds only

[ahmed_hassan]

Dear all,

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

1.  Insert Only
2. Insert and Update
3. 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 🙂 

[tresesco]

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