topic Loading multipe Excel and sheet in qlik Sense in App Development

Loading multipe Excel and sheet in qlik Sense

nizamsha — Tue, 27 Nov 2018 09:59:40 GMT

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

Re: Loading multipe Excel and sheet in qlik Sense

nasirsaikh — Wed, 28 Nov 2018 08:49:58 GMT

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);

Re: Loading multipe Excel and sheet in qlik Sense

nasirsaikh — Wed, 28 Nov 2018 08:50:33 GMT

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)
;