Dynamic load of files from a folder

arethaking — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have the different text files like T1.txt,T2.txt,A1.txt,B1.txt

and the different text files like T3.xlsx,T4..xlsx,A2..xlsx,B2.xlsx

in folder D:\SourceFiles.

How to load all the files into qlikview application?

Re: Dynamic load of files from a folder

Anil_Babu_Samineni — Mon, 29 May 2017 04:23:21 GMT

Simple solution is this? And make sure the structure should be same for each files either .txt or .xls

AllFiles:

LOAD Sample

FROM

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq, header is 1 lines, filters(

Remove(Row, Pos(Top, 3))

));

Join

LOAD Name

FROM

(ooxml, embedded labels, table is Sheet1);

STORE AllFiles into D:\SourceFiles\AllFiles.qvd (qvd);

PS - Here, i attached the files like txt, excel, qvd, qvw and script. please have a look zip file. May be helps you