Discussion Board for collaboration on QlikView Scripting.
Sub createanddrop (vTableName)
Store $(vTableName) into [$(vTableName).qvd];
Drop Table [$(vTableName)];
// 2nd subroutine
FOR i=1 to NoOfTables();
LET vTable=TableName($(i) -1);
//Main call to subroutine
This is my code....I want to use call within a subroutine, so that I can pass parameter to another subroutine.
Go to Solution.
Solved. Here it is:
Drop Table $(vTableName);
FOR i=1 to NoOfTables() -1;
It should work.
I think your code its fine. It should work.
Plz go through my code....
its not working.......I am not able to bring my table name to 1st subroutine
I would also modify line 2
Store [$(vTableName)] into [$(vTableName).qvd] (qvd);
FOR i=1 to NoOfTables() ;
Not sure it will work
If you delete a table, what will be the next time the result of TableName (counter) when you increment your counter. I think you will skip some tables.
Certainly, you have to get your table to export and delete through a simple TableName(0). And do a loop as you did (certainly by storing NoOfTable into a variable)