topic Re: Extract entire folder in QlikView

Extract entire folder

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

Hi,

I have one folder contains many xls files.

I want to extract entire folder,how to extract it in qlikview.

Re: Extract entire folder

Anil_Babu_Samineni — Wed, 27 Dec 2017 06:12:40 GMT

Is that folder carrying 10 Excels. So, does 10 excels having same structure of fields??

Re: Extract entire folder

dhavalvyas — Wed, 27 Dec 2017 06:13:36 GMT

yes all the fields are same

Re: Extract entire folder

Chanty4u — Wed, 27 Dec 2017 06:17:28 GMT

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

Re: Extract entire folder

tresB — Wed, 27 Dec 2017 06:17:54 GMT

Try using wildcard character like:

LOAD

FROM

[<your path>\ *.xls]

(biff, embedded labels, table is ITEM$);

Re: Extract entire folder

Anil_Babu_Samineni — Wed, 27 Dec 2017 06:18:59 GMT

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

Re: Extract entire folder

devarasu07 — Wed, 27 Dec 2017 06:19:51 GMT

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

Re: Extract entire folder

shiveshsingh — Wed, 27 Dec 2017 07:21:28 GMT

You can try with wildcard character

LOAD

FROM

[<File path>\ *.xls]

Re: Extract entire folder

dhavalvyas — Wed, 27 Dec 2017 08:16:18 GMT

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

Re: Extract entire folder

Anil_Babu_Samineni — Wed, 27 Dec 2017 08:57:53 GMT

There are 4 replies including me, How come we know which script you used for?

Re: Extract entire folder

shiveshsingh — Wed, 27 Dec 2017 09:47:52 GMT

What are the column names? you need to put the column names and what type of error are you getting while executing? Can u paste a snap?