topic Re: load multiple excel files with for loop in QlikView

load multiple excel files with for loop

Mon, 22 Jun 2015 10:26:26 GMT

Hello,

I have five excel sheets with different column names. I want to load this with a for loop(without load data with 'table files': is this possible?).

The names of the files are: file1, file2, file3, file4 and file5.

I have found this script:

FOR a=1 to 5

LOAD * FROM C:\Users\name\Documents\Qlikview\script\file$(a).xls;

FOR counter=1 to 5 step 2

SET filename=x$(counter).xls;

IF rand( )<0.5 THEN

EXIT For Unless counter=1

END IF

LOAD * FROM $(filename);

But I get the error: cannot find: LOAD * FROM x1.xls.

Can someone help me? What is wrong?

thanks in advance.

Mon, 22 Jun 2015 10:44:39 GMT

Hi Maichel,

Could you please explain this query little bit.

Did not get what exactly you are looking for

Regards

Anonymous — Mon, 22 Jun 2015 10:46:33 GMT

No need for a loop, just

LOAD * FROM C:\Users\name\Documents\Qlikview\script\file*.xls;

Anonymous — Mon, 22 Jun 2015 10:47:28 GMT

use the script Editor and load one of the files using wizard.

in your load LOAD * FROM C:\Users\name\Documents\Qlikview\script\file$(a).xls;

the tab is missing from which Qlikview should load

d_koti24 — Mon, 22 Jun 2015 10:48:57 GMT

Hi,

Go Through This link,it will help you

Regards,