Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

cancel
Showing results for 
Search instead for 
Did you mean: 
narayanaqlik
Creator
Creator

No Qualified path error in qliksense

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

 

 

 

 

2 Replies
anushree1
Specialist II
Specialist II

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
Creator
Creator
Author

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.

like 

SUB StoreAndDrop(varTableName)

$(varTableName):

Load *.

from $(varDBName).$(varTableName);

End Sub

Call StoreAndDrop(TableName1);

Call StoreAndDrop(TableName1);

.

.

.

 

So, Here  i am facing issue from and varDBName

so here how can i mention the path names.