problem whith data load

[bbmmouha]

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 ??

[jvitantonio]

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]

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]