Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have one folder contains many xls files.
I want to extract entire folder,how to extract it in qlikview.
Is that folder carrying 10 Excels. So, does 10 excels having same structure of fields??
yes all the fields are same
can you tell me the file names list?
for example your filenames like below
Sample_jan17
Sample_feb17
Sample_mar17 ....... like so on..
test:
load *,
..
..
FROM
(ooxml, embedded labels, table is Sheet1);
Try using wildcard character like:
LOAD
*
FROM
[<your path>\ *.xls]
(biff, embedded labels, table is ITEM$);
Can you call them it is using Sub directory
SET Path = '\*.xls';
SUB DoDir (Root)
FOR each File_Copy in filelist(Root& '$(Path)')
LOAD * FROM [$(File_Copy)] (biff, embedded labels);
NEXT File_Copy
FOR each AllFiles in dirlist (Root&'\*')
Call DoDir(AllFiles)
NEXT AllFiles
END SUB
CALL DoDir('AZ:\Prod\Sample\Folder\AMI63')
Hi,
have you tried this method?
Loading Multiple Excel files to QlikView | Qlik Community
Load all Excel files and all sheets in a folder
basic code:
let ExcelSource = 'D:\Excel Source\Sales*.xlsx';
for each File in filelist (ExcelSource)
AllData:
LOAD * FROM $(File) (ooxml, embedded labels, table is Sheet1);
next File
You can try with wildcard character
LOAD
*
FROM
[<File path>\ *.xls]
Should we specify any field name after load * , statement ? As I am using your code but it is not working ? after extracting it I have to store it in .csv file
There are 4 replies including me, How come we know which script you used for?