topic Re: No Qualified path error in qliksense in App Development

No Qualified path error in qliksense

narayanaqlik — Thu, 13 Feb 2020 05:41:37 GMT

HI All,

I have written a logic to fetch the data based on variable value either full or Incremental load but i am facing some error

Already i have mentioned the DB Connection in top

and i have taken DB Name and table names are in variable.

all the tables will be called based on the SUB routines

Please find below script and the error also and give any one good logic

let varInitLoad=1;

//=======================Sub function to Store QVDs===========================================================//

Sub StoreAndDrop(varTableName,varCreateDate,varInitLoad)

let varReload=$(varInitLoad);

if varReload=1 then

$(varTableName):

Load *

FROM "$(varDBName)"."$(varTableName)" order by $(varCreateDate);

Let varMaxDate= Peek('$(varCreateDate)',-1,'$(varTableName)');

Store [$(varTableName)] into [$(varRawQVDPath)\$(varTableName).qvd];

Drop Table [$(varTableName)];

Endif

End Sub

Call StoreAndDrop('TRIAL_INFO','CREATED_AT','1');

Error: The following error occurred:

No qualified path for file: ***

The error occurred here:

TRIAL_INFO: Load * FROM "DIT_FIRST_USER_R3"."TRIAL_INFO" order by CREATED_AT

anushree1 — Thu, 13 Feb 2020 06:46:45 GMT

Try Loading the data by selecting the table post test connection without the variables, that might help you figure out where the issue is

narayanaqlik — Thu, 13 Feb 2020 07:44:44 GMT

Hi Anushree1

Thanks for your reply..!

Yes, If i am loading after load connection it is working.

But here i am trying to load all the required tables from DB By mentioning the table Name, Below DB path name name table name.

SUB StoreAndDrop(varTableName)

$(varTableName):

Load *.

from $(varDBName).$(varTableName);

End Sub

Call StoreAndDrop(TableName1);

So, Here i am facing issue from and varDBName

so here how can i mention the path names.