Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ??
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
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]