Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

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

Hi,

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