topic Re: Looping multiple .xlsx files in QlikView

Looping multiple .xlsx files

Anonymous — Thu, 15 Jan 2015 12:31:17 GMT

i have Excel file with a naming structure "OnBillingReportsNov2014","OnBillingReportsOct2014" continuing for all months

i and tying to use the below script to load the field from all months but i get an error on "next file " what could be wrong with my code?

if there is a better way to achieve this help

i am using this:

Set vFolder = 'C:\Users\abb\vvvv\WORK\OnBilling';

for each File in filelist(vFolder& '\OnbillingReports*.xlsx')

VCBill:

LOAD Date,

Reference,

Amount,FileName() as id

FROM

[$(File)]

(ooxml, embedded labels, table is [VC Bill]);

next file

Re: Looping multiple .xlsx files

giakoum — Thu, 15 Jan 2015 12:33:09 GMT

Next File

can it be that you have it lowercase?

Re: Looping multiple .xlsx files

Anonymous — Thu, 15 Jan 2015 12:34:27 GMT

why not loading

VCBill:

Load Date,

Reference,

Amount,,

Filename() as id

from $(Folder)'OnBillingReports*.xlsx'

Re: Looping multiple .xlsx files

Thu, 15 Jan 2015 12:36:20 GMT

I agree with Ioannis. File in your case is an identifier. Try to keep the same letter cases on them.

Re: Looping multiple .xlsx files

Anonymous — Thu, 15 Jan 2015 12:40:32 GMT

Thanx for ur responds i have tried it and it worked but the whole script is way more than i had put i will try and use your idea as i work through then iw ill come back to tou

thank you however