Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Multiple excel files to load in QVDs without overwriting

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

Labels (1)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

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);
Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

1 Reply
Highlighted
Partner
Partner

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);
Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post