Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
Just to be precise, I know how to use Incremental load from the general 3x cases:
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 🙂