topic Re: Incremental Load Issue in QlikView

Incremental Load Issue

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have one excel table. In that table there are few columns for example.

Customer-PO Date (Date)

CustomerName (Text)

Product_Line (Text)

Weight (Number)

Now i want to implement increment load in above table. It means i want to get new records and modified records.

I also attached qvw & excel file for your reference.

Thanks in advance!!

Anonymous — Thu, 09 Nov 2017 07:34:03 GMT

Anybody help on this issue!!

Sergey_Shuklin — Thu, 09 Nov 2017 08:15:40 GMT

Hello!

You want to load new date with new data rows and in some cases modify existing rows of previous dates?

Or just add a new date rows?

Anonymous — Thu, 09 Nov 2017 09:45:27 GMT

Just wanted to insert new date rows.

MayilVahanan — Thu, 09 Nov 2017 09:59:07 GMT

PFA.

Hope it helps

Anonymous — Thu, 09 Nov 2017 11:22:20 GMT

Thank you for your reply,

I have tried your solution, however at first it worked after that for testing i inserted 2 new rows n tried to reload qvw.

Its showing following result:

I have attached excel file for reference. could you please check it and suggest what could be the issue.

Much Thanks!

Anonymous — Thu, 09 Nov 2017 12:04:43 GMT

I have attached QVW ,qvd and Datasource(EXCEl)

even added new data to test it for updating QVD on maxdate

its work fine

Regards

Sahadev