Hi, Rohit Kumar.
My suggestion is:
Create a key field to control the modification, because each key field is a fact. See example below of incremental load insert and update (no delete).
Last_update_date:
LOAD
Distinct
Max(Date([Invoive Date])) AS Maxdate
FROM
(qvd);
Let vLast_update_date = Date(peek('Maxdate',0,'Last_update_date'),'MM/DD/YYYY');
DROP Table Last_update_date;
SampleinputQVD:
LOAD
([Sale Source] & '_' & [Transaction ID] & '_ ' & [Customer ID] & '_' & [Customer Area code] & '_' & [Bill No] & '_' & [Product Name] & '_' & Date([Invoive Date]))
AS [Modification Data],
[Sale Source],
[Transaction ID],
Date([Invoive Date]) AS [Invoive Date],
[Customer Detail],
[Customer ID],
[Customer Area code],
[Bill No],
[Product Name],
[Transaction mode],
[Product quantity],
[Total sales amount]
FROM
(ooxml, embedded labels, table is Sheet1)
Where
Date([Invoive Date]) >= '$(vLast_update_date)';
Concatenate
LOAD [Sale Source],
[Transaction ID],
Date([Invoive Date]) AS [Invoive Date],
[Customer Detail],
[Customer ID],
[Customer Area code],
[Bill No],
[Product Name],
[Transaction mode],
[Product quantity],
[Total sales amount],
[Modification Data] //Already create in QVD.
FROM
(qvd)
where not Exists([Modification Data]);
STORE SampleinputQVD into
(qvd);
DROP Table SampleinputQVD;
P.S.: create a key field in QVD before run script. Utilize the attached that already exist (Modification Data field).
I hope this helps!
Jonas Melo.
