Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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