Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
Showing results for 
Search instead for 
Did you mean: 

Append new data to existing QVC file from set name Xlsx file. Overwriting lines with distinct value.


I'm still new to Qlik Sense and I have encountered an issue that I can't quite solve.

I have a file that is created daily (Day001.xlsx).

The data values I will load are Tm, Wt and LineID.

I want to store this into a QVC file (Daily001.qvc) every day.

But I want only unique lines in the QVC table. I have a unique value per line (LineID) in the data.


How could I write the LOAD SCRIPT as to have the new data overwrite lines in the existing in Daily001.qvc but leave the rest intact?


Thank you in advance for your assistance.

0 Replies