Discussion board where members can get started with Qlik Sense.
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.