Script

[#1]

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 · Accepted solution]

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

[#3]

Thanks brother u always rock

[#4]

Hi,

Try this

Load * From

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

Regards

Ayush