topic Re: Script in QlikView

Script

Thu, 11 Dec 2014 05:50:52 GMT

hi All,

Actaully i have 6 months different excel sheets , I wanted to write a script where upon i can laod all the excel sheets at once .

iam attaching here my problem , i hope u will understand it ,

Thanks in Advance.

its_anandrjs — Thu, 11 Dec 2014 06:01:40 GMT

Try to write like this way i create single variable to store the Path of the files in the variable and from this folder load all *.csv files.

LET Path = 'D:\POC Disney\Trxn\Transaction_Files-2014-12-10\Transaction Files\';

Load *
From

[Path\*.csv];

Regards

Anand

Thu, 11 Dec 2014 06:23:59 GMT

Thanks brother u always rock

Thu, 11 Dec 2014 06:27:09 GMT

Hi,

Try this

Load * From

[D:\POC Disney\Trxn\Transaction_Files-2014-12-10\Transaction Files\*.csv];

Regards

Ayush