Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Anonymous
Not applicable
Author

Anybody help on this issue!!

Sergey_Shuklin
Specialist
Specialist

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
Not applicable
Author

Just wanted to insert new date rows.

MayilVahanan

HI

PFA.

Hope it helps

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Anonymous
Not applicable
Author

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!

Anonymous
Not applicable
Author

HI

Regards

Sahadev