topic Cannot open file 'file path' in QlikView

Cannot open file 'file path'

Sat, 11 Jan 2014 00:08:03 GMT

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_Transform_Load/Extract_Transform_Load.htm

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

Re: Cannot open file 'file path'

Mon, 13 Jan 2014 09:35:11 GMT

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

Re: Cannot open file 'file path'

Mon, 13 Jan 2014 09:45:35 GMT

Hi,

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

Hope this helps!

Re: Cannot open file 'file path'

Mon, 13 Jan 2014 09:54:30 GMT

Hi,

give complete path after from clause like

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

Regards,

abhishek

Re: Cannot open file 'file path'

jonathandienst — Mon, 13 Jan 2014 09:58:44 GMT

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

Re: Cannot open file 'file path'

zheryeh01 — Sun, 04 Mar 2018 17:37:25 GMT

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