Discussion board where members can get started with QlikView.
Hi everyone... i would like to load n files which have same estructure but their extentions are differents... and also... the name of which sheet in excel can be named different.....
how i can load in a masive load way?
You need to create a source table list first and then load can be triggered.
LOAD * Inline [
For i = 1 to NoOfRows('SourcesLocation')-1
vFile = Peek('Location',$(i),'SourcesLocation')&'\'&Peek('FileName',$(i),'SourcesLocation');
vType = Peek('Source',$(i),'SourcesLocation');
vSheet = Peek('Sheet',$(i),'SourcesLocation');
if $(vSheet) = 'xls' then
(ooxml, embedded labels, header is 0 lines, table is $(vSheet));
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
The If else conditions are based on load file types. You can add delimiter column to SourceLocation if that changes from sources.