topic Re: Facing issue to open excel file in QlikView

Facing issue to open excel file

Fri, 06 Sep 2013 12:00:47 GMT

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 — Fri, 06 Sep 2013 12:07:07 GMT

Have you double checked that the path is valid?

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

rajeshvaswani77 — Fri, 06 Sep 2013 12:08:34 GMT

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

Fri, 06 Sep 2013 12:09:01 GMT

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