Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Drop Table $(variableTableName);

Hi Guys,

i'm trying to use a variable table name into the Drop Table instruction and that seems to not work as intended.

Indeed, i'm working with tables generated according to variable names like :

FOR EACH vInputFile In FileList('.\INPUTS\*')

     ...

     $(currenttablename)$(tablesuffix):

     LOAD * FROM InputFile;

     ...

     STORE $(currenttablename)$(tablesuffix) INTO '.\STORE\$(currenttablename)';

NEXT vInputFile

And after that, i have to purge memory :

FOR iTableNo = 0 to NoOfTables()-1

     Let CurrentTable = TableName('$(iTableNo)');

     IF WildMatch(CurrentTable,'*$(tablesuffix)') THEN

          Drop Table $(CurrentTable);

     ENDIF

NEXT

My problem is that this statement : Drop Table $(CurrentTable);

The variable table name seems to not be replaced correctly during execution, and QV return and error :  "Table unavailable : Drop Table statement"

Is drop table working with variable table name ?

Thanks in advance for your help.

1 Reply
fosuzuki
Valued Contributor II

Re: Drop Table $(variableTableName);

Hi,

Yes it should work with dollar sign expansion.

Does any of the CurrentTable values has a space in it? If yes, the DROP must be adjusted to:

Drop Table [$(CurrentTable)];

FOS

Community Browser