Assistance required on Incremental load

[#1]

Hi,

I am looking for updation in two table. Input file sheet contains 4 records and Input file1 contains 5 records.

Input file1 contains 2 records in which Sales amount vaue change.

I try to run the incremental but it is simply appending all the records. These two records has not been updated with earlier entry.

Please find the sample input file, QVW and expected result as attached.

Thanks in advance!!

Rohit

[rahulpawarb]

Hello Rohit,

Please refer below sample script:

TEST:
LOAD Products, 
     [Customer ID], 
     [Transaction Date], 
     [Sales Qty], 
     [Sales Amount], 
     [Country Code]
FROM
Input file1.xlsx
(ooxml, embedded labels, table is Sheet1);
Concatenate
LOAD Products, 
     [Customer ID], 
     [Transaction Date], 
     [Sales Qty], 
     [Sales Amount], 
     [Country Code]
FROM
Input file.xlsx
(ooxml, embedded labels, table is Sheet1)
Where NOT Exists(Products);

Also refer the attached sample application.

Regards!

Rahul

[#3]

Hi Rahul,

While doing this Product A and B is still showing Sales Amount as 10 and 20. It has not been updated with the new Sales Amount.

Thanks,

Rohit

[rahulpawarb]

Hello Rohit,

I believe that you are using Input file.xlsx in first load statement & Input file1.xlsx in second load statement. Please refer above given script where we loaded these files in reverse order (also refer the attached application file; where you will get desired results).

If you are still facing issues then let me know.

Hope this will be helpful.

Regards!

Rahul