Facing issue to open excel file

[#1]

hi All,

i ma getting below error: 

Cannot open file 'C:\Qlikview\APP\SRC\InControl\FI\XLS\EBD\*.xls' The system cannot find the path specified.

EBDTeamMap:

Mapping LOAD Mid(Filename(),len(Filename())-10,7) & '-' & Num(Employee_EmployeeId) as EBD_Employee_MonthKey,

  Organisation_UnitName as Team

FROM [..\SRC\InControl\FI\XLS\EBD\*.xls] (biff, embedded labels, table is Data$)

similar code is working at other places and only this code is giving issue.

any suggestions?

Thanks,

Rahul

[swuehl]

Have you double checked that the path is valid?

Using a relative path might be problematic when copying around applications.

[rajeshvaswani77]

Hi Rahul,

Looks like something to do with the ..\

Your QlikView application is not getting the excel file.

try this.

SET vFilePath =''C:\Qlikview\APP\SRC\InControl\FI\XLS\EBD\';

EBDTeamMap:

Mapping LOAD Mid(Filename(),len(Filename())-10,7) & '-' & Num(Employee_EmployeeId) as EBD_Employee_MonthKey,

  Organisation_UnitName as Team

FROM [$(vFilePath)*.xls] (biff, embedded labels, table is Data$)

verify that the file path variable has the correct path.

thanks,

Rajesh Vaswani

[#4]

Hi All,

It was a big typo from my side. i have created folder name EDB and trying to access EBD.

Big lesson for the day!

Thanks,

Rahul