Multiple excel files to load in QVDs without overwriting

[mja_jami]

Hello Qlik experts, 

I’ve multiple excel files that contain monthly data for 2016, 2017 and I’ve a QVD which has 2018’s data in it. All I want is to add that data into existing QVD without overwriting the existing 2018 data in it. 

Should I turn excel files into QDVs and then concatenate? Please suggest the best practice and script that will load data from excel and script for concatenate 2018’s QVD.

Thank you very much for your help.

Best regards,

Jami

[Vegar · Accepted solution]

Try
Data:
Load *
From LIB://QVD/data.qvd (qvd) //existing 2018 data
;
// L Loop through and concatenate your excel files
For each vExcelFile in '2018_data.xls', '2016_2017_data.xls'
Concatenate (Data)
LOAD
*
From LIB://EXCEL/$(vExcelFile) (biff, .... )
;
NEXT
Store Data into LIB://QVD/data.qvd (qvd);