No Qualified path error in qliksense

[narayanaqlik]

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]

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]

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.