topic Re: hi in QlikView

hi

Thu, 20 Nov 2014 10:01:12 GMT

can any one explain how to load multiple excel files in single script ? take one scenario .

Fri, 21 Nov 2014 02:24:32 GMT

try this

for Each vMonth in 'Jan','Feb','Mar','Apr','May','Jun'

Data:

LOAD ID,

State,

'$(vMonth)' as Month,

Sales

FROM

SALES_M.xlsx

(ooxml, embedded labels, table is $(vMonth));

NEXT vMonth

here:

in your xl sheet names like jan ,feb,mar ......

change the names based on ur sheets

jagan — Fri, 21 Nov 2014 02:28:33 GMT

Hi,

If all the files are of the same format ie., same columns then try like this using wildcard characters.

Data:

LOAD

FileName() AS SourceFile

FROM

*.xlsx

(ooxml, embedded labels, table is Sheet1);

Hope this helps you.

Regards,

Jagan.

Anonymous — Fri, 21 Nov 2014 02:51:28 GMT

Hey,

you may try this to load files from a same folder with similar structure:

For each file in FileList('C:\Users\chinna\Documents\QlikView\*')

TEMP_FILE:

LOAD

subfield('$(file)','\',-1) as filename,

FileTime('$(file)') as Date_file autogenerate 1;

Next;

BR,

Chinna