Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

remyasujith17
New Contributor III

No qualified path for file: ***

Error while loading excel file

[Map]:

LOAD CountryId,

country,

Lat,

Long

FROM

[lib..//Xls\Map.xls]

(ooxml, embedded labels, table is Sheet1);

Path:patherror.png

1 Solution

Accepted Solutions
agigliotti
Honored Contributor II

Re: No qualified path for file: ***

below syntax for connection string is wrong

[lib..//Xls\Map.xls]

please follow the wizard to insert string connection.

8 Replies
ChennaiahNallani
Contributor III

Re: No qualified path for file: ***

share error name or loge file

remyasujith17
New Contributor III

Re: No qualified path for file: ***

2018-03-01 11:56:44 0071 [Map]:

2018-03-01 11:56:44 0072 LOAD CountryId,

2018-03-01 11:56:44 0073 country,

2018-03-01 11:56:44 0074 Lat,

2018-03-01 11:56:44 0075      Long

2018-03-01 11:56:44 0076 FROM

2018-03-01 11:56:44 0077 [lib..//Xls\Map.xls]

2018-03-01 11:56:44 0078 (ooxml, embedded labels, table is Sheet1)

2018-03-01 11:56:44      Error: No qualified path for file: ***

2018-03-01 11:56:44      Execution Failed

2018-03-01 11:56:44      Execution finished.

ChennaiahNallani
Contributor III

Re: No qualified path for file: ***

check you connection

Capture.PNG

Long

    Description

FROM [lib://Connection/Telecom Data.xlsx]

(ooxml, embedded labels, table is [data dictionary]);

YoussefBelloum
Esteemed Contributor

Re: No qualified path for file: ***

Hi,

did you try another path just to test ?

create another lib (with a shorter path) and try to load from it.

did you opened the exact path on a "windows" window and found your file ?

agigliotti
Honored Contributor II

Re: No qualified path for file: ***

below syntax for connection string is wrong

[lib..//Xls\Map.xls]

please follow the wizard to insert string connection.

remyasujith17
New Contributor III

Re: No qualified path for file: ***

Hi,

Yes I  opened the path its correct.

I tried another path also.

YoussefBelloum
Esteemed Contributor

Re: No qualified path for file: ***

Like Andrea said here, did you wrote the lib line by yourself or did you use the the Wizard ?

remyasujith17
New Contributor III

Re: No qualified path for file: ***

Thanks