topic Re: Problem Loading .CSV data in QlikView

Problem Loading .CSV data

Tue, 15 Dec 2015 13:08:01 GMT

I am loading monthly data into a document and it keeps returning.

Cannot open file 'S:\Management Information Team\Cross Division Reporting\Monthly Reports\2015\11-November\00 Data Files\MI1511_100D_ADT_LDM_Due_*.csv' The system cannot find the file specified.

I have checked the path and the actual file name both of which are correct.

Any ideas

Re: Problem Loading .CSV data

Gysbert_Wassenaar — Tue, 15 Dec 2015 16:43:39 GMT

Are you loading it using Qlikview Desktop? Or using Qlikview Server? If the latter check that the service account used can access that file using that path.

Re: Problem Loading .CSV data

Tue, 15 Dec 2015 16:45:47 GMT

Hi,

No the file in question had been closed for around 15 minutes prior to use.

On 15 December 2015 at 16:44, Gysbert Wassenaar <qcwebmaster@qlikview.com>

Re: Problem Loading .CSV data

hallquist_nate — Tue, 15 Dec 2015 21:29:39 GMT

Is it a mapped drive? If so, you might have to use an IP address or Server name, rather than a drive letter.

It also looks like it could be relative path. Relative Paths only work if the QVW file stays in the location it was originally saved in. For example, if you have a QVW on a server and you move it from it's location and put it in a new location, like the desktop, the relative path won't work.

Hope those help,

Nate