Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bbmmouha
Creator
Creator

problem whith data load

hello community

i have a problem whith load data this the error

No qualified path for file: ***: fpa : Load * FROM [preprod].[fpa] WHERE dt_rcp_mod>03/07/2018


and whene i replace [preprod].[fpa] whith the qvd link it work fine


there is any restriction to use [].[] in the instruction from ??

2 Replies
jvitantonio
Luminary Alumni
Luminary Alumni

Hello bbm, this is Qlik Sense Load statement and as such you should you a library connection right after the FROM keyword. For example:

LOAD * FROM [LIB://MyFiles/fpa.qvd] (qvd);

Make sure you first create the connection pointing to your file.

If, on the other hand, you ae trying to query your database, the sintax is as follow:

LIB CONNECT TO "MyDBConnection";

[MyTable]:

SQL

SELECT * FROM fpa WHERE dt_rcp_mod>03/07/2018

;

I hope this helps.

Regards

Juan

bbmmouha
Creator
Creator
Author

thanks @juan i think ther is a problem whith the impala connector when i specify a data base Preprod and i do the data request like you mention it didn't work and i m obligate to write [preprod].[fpa]