Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Cannot open file 'file path'

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$])

5 Replies
Not applicable
Author

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

Not applicable
Author

Hi,

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

Hope this helps!

Not applicable
Author

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
Partner - Champion III
Partner - Champion III

Hi

I think this is what you need:

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

[C:\Temp\Qlik View Tuts\Work\Build you first QlikView document _Exercises\DATA\SALESDATA.xls]

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



HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
zheryeh01
Contributor
Contributor


Hi John Wayne,
I think your problem is just that you have not put a semi-colon ( ; ) just after your path.