Discussion board where members can learn more about Qlik Sense App Development and Usage.
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
//=======================Sub function to Store QVDs===========================================================//
if varReload=1 then
FROM "$(varDBName)"."$(varTableName)" order by $(varCreateDate);
Let varMaxDate= Peek('$(varCreateDate)',-1,'$(varTableName)');
Store [$(varTableName)] into [$(varRawQVDPath)\$(varTableName).qvd];
Drop Table [$(varTableName)];
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
Try Loading the data by selecting the table post test connection without the variables, that might help you figure out where the issue is
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.
So, Here i am facing issue from and varDBName
so here how can i mention the path names.