topic DROP TABLES WITH A REGULAR EXPRESSION in QlikView

DROP TABLES WITH A REGULAR EXPRESSION

Wed, 13 Oct 2010 12:21:53 GMT

Hi everyone,

Do you know if I can do something like this?

DROP TABLE table*;

If I had a lot of tables like 'table1', 'table2',....'table300' and I´d like to dropt it, could be an easy way to delete all the tables.

I know that I can make a For..Next to delete all the tables, but I dont know if I can use regular expressions.

Thanks a lot.

DROP TABLES WITH A REGULAR EXPRESSION

Mon, 18 Oct 2010 11:08:15 GMT

I know it's an irritating answer, but: why?

I mean, if you have numbered tables containing similar values, why you do not load them in a single, common table instead of loading them separatedly?

Probably I'm missing something.

Bye

DROP TABLES WITH A REGULAR EXPRESSION

Mon, 18 Oct 2010 16:27:31 GMT

Hi chisea80,

My question is not about how to load tables with similar values.

My question is about if I can use a regular expression to delete some tables at the same time, this tables could be similar or not it doesn´t matter.

Thanks.

DROP TABLES WITH A REGULAR EXPRESSION

johnw — Mon, 18 Oct 2010 20:34:13 GMT

The simple answer is no. Tables must be explicitly listed and there's no support for regular expressions.

But if your actual testing can be done with a wildmatch(), you could handle it by looping through all the tables, like so:

FOR i=nooftables()-1 TO 0 STEP -1
LET vTable=tablename(i);
IF wildmatch(vTable,'table*') THEN
DROP TABLE $(vTable);
END IF
NEXT

DROP TABLES WITH A REGULAR EXPRESSION

Tue, 19 Oct 2010 09:51:57 GMT

Ok, thanks a lot