topic Re: Assistance required on Incremental load in QlikView

Assistance required on Incremental load

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Assistance required on Incremental load

rahulpawarb — Fri, 05 May 2017 07:16:10 GMT

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

Re: Assistance required on Incremental load

Fri, 05 May 2017 07:30:32 GMT

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

Re: Assistance required on Incremental load

rahulpawarb — Fri, 05 May 2017 09:22:50 GMT

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