Re: Cannot open file 'file path' - Qlik Community

Report Inappropriate Content · ‎2014-01-10

I was trying to do the ETL tutorial for Qlick view at - http://qvtraining.qlik.com/DOWNLOADS_FREE-ELEARNING/Build_Your_First_QlikView/Mod_2_Extract_Transfor...

I got the error below. I selected the correct file SALESDATA.xls from the correct folder, but the error shows that qlik view is

looking for the file in the wrong folder. Actual path is - C:\Temp\Qlik View Tuts\Work\Build you first QlikView document _Exercises\DATA\SALESDATA.xls

Strangely, the script execution progress window says that 39,984 rows are being loaded. After I click ok, then I can see a list of the fields.

Why does this error happen and how to fix it ?

Error -

Cannot open file 'C:\Temp\Qlik View Tuts\Work\Qlik Tutorial Exercises\SALESDATA.xls' The system cannot find the file specified.

LOAD [Actual Delivery Date],

CustKey,

DateKey,

[Discount Amount],

[Invoice Date],

[Invoice Number],

[Item Class],

[Item Number],

Item,

[Line Number],

[List Price],

[Order Number],

[Promised Delivery Date],

[Sales Amount],

[Sales Amount Based on List Price],

[Sales Cost Amount],

[Sales Margin Amount],

[Sales Price],

[Sales Quantity],

[Sales Rep],

[U/M]

FROM

SALESDATA.xls

(biff, embedded labels, table is [Sheet1$])

Report Inappropriate Content · ‎2014-01-13

Hi John,

Follow below tips.

1) Don't keep spaces when you are giving the folder name, give it full string, either Underscore.

2) Try to create one folder structure and start you devlopment.

Santhosh G

Report Inappropriate Content · ‎2014-01-13

Hi,

Check if your QVW file and excel exist in the same folder? Also, follow the suggestions provided by @Santhosh.

Hope this helps!

Report Inappropriate Content · ‎2014-01-13

Hi,

give complete path after from clause like

(To learn mode press ctrl+N and follow the wizard to import excel file)

Regards,

abhishek

jonathandienst · ‎2014-01-13

Hi

I think this is what you need: