topic Re: How to create a loop for extracting the data from multiple .xlsx files in QlikView

How to create a loop for extracting the data from multiple .xlsx files

madhubabum — Wed, 16 Sep 2015 12:19:38 GMT

Hi All

I have one Folder with 5 Excel(.xlsx) files

I want to extract the data from excel files with a loop condition.(create a next loop) ?

How can we implement ?

Thanks

Madhu

Re: How to create a loop for extracting the data from multiple .xlsx files

alexandros17 — Wed, 16 Sep 2015 12:26:22 GMT

here it is an example:

let path_Pallet = '..\..\*.xlsx';

for each File in filelist (path_Pallet)
PalletInfo:
LOAD * FROM $(File) (ooxml, embedded labels, table is Foglio1);
next File

Re: How to create a loop for extracting the data from multiple .xlsx files

Wed, 16 Sep 2015 12:30:23 GMT

do the files have a consistant naming convention - if they do, you can use a wild card in the file name in the load script

Re: How to create a loop for extracting the data from multiple .xlsx files

madhubabum — Wed, 16 Sep 2015 12:43:38 GMT

Hi Alessandro

If an error occurred , how can we identify ?

Thanks

Madhu

Re: How to create a loop for extracting the data from multiple .xlsx files

Colin-Albert — Wed, 16 Sep 2015 12:46:35 GMT

Enable the document log and look at the log file.