Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
NullVoid
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