Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nizamsha
Specialist II
Specialist II

Loading multipe Excel and sheet in qlik Sense

Hello  everyone..

 

I am having a issue in Loading multiple excel and sheets at a same time in qlik Sense..

2 Problems i have while loading Excel sheets some time there is a mismatch in the sheet name and also column name even through i have to load the particular sheet but its failing to load..

What will be the solution to load the data even we have these issue..

 

Regards

Nizam

 

2 Replies
nasirsaikh
Creator
Creator

Hi Nizam, Try below code... for each vFile in FileList('..\Data\*.csv') let vQVD = replace(vFile, '.csv', '.qvd'); if alt(FileSize('$(vQVD)'), 0) = 0 then NextFile: LOAD * FROM $(vFile) (txt, codepage is 1252, no labels, delimiter is ',', msq) ; STORE NextFile INTO $(vQVD) (qvd); DROP TABLE NextFile; end if next Data: LOAD* FROM ..\Data\*.qvd (qvd);
nasirsaikh
Creator
Creator

for each vFile in FileList('..\Data\*.csv')
let vQVD = replace(vFile, '.csv', '.qvd');

if alt(FileSize('$(vQVD)'), 0) = 0 then
NextFile:
LOAD
*
FROM $(vFile)
(txt, codepage is 1252, no labels, delimiter is ',', msq)
;

STORE NextFile INTO $(vQVD) (qvd);

DROP TABLE NextFile;
end if
next

Data:
LOAD
*
FROM ..\Data\*.qvd (qvd)
;