topic Re: problem whith data load in App Development

problem whith data load

bbmmouha — Thu, 09 Aug 2018 09:53:22 GMT

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

Re: problem whith data load

jvitantonio — Thu, 09 Aug 2018 14:10:08 GMT

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

Re: problem whith data load

bbmmouha — Fri, 10 Aug 2018 07:16:21 GMT

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]