Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Incremental Load Issue

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!!

6 Replies
Highlighted
Contributor III
Contributor III

Re: Incremental Load Issue

Anybody help on this issue!!

Highlighted
Specialist
Specialist

Re: Incremental Load Issue

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?

Highlighted
Contributor III
Contributor III

Re: Incremental Load Issue

Just wanted to insert new date rows.

Highlighted

Re: Incremental Load Issue

HI

PFA.

Hope it helps

Highlighted
Contributor III
Contributor III

Re: Incremental Load Issue

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:

Test11.JPG

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

Much Thanks!

Highlighted
Contributor III
Contributor III

Re: Incremental Load Issue

HI

Regards

Sahadev