topic Re: qlikview script: Drop all tables where table name like '%%' ? in QlikView

qlikview script: Drop all tables where table name like '%%' ?

Wed, 26 Nov 2014 09:41:39 GMT

Hi,

I have a script which is generating the dimension tables dynamically so we are not sure what are the tables names going to be. We just know that the table names are going to be started with C_

I wonder if at the end of script, there is someway to dynamically get the names of all the tables that start with C_ and then drop them all

Shah

Re: qlikview script: Drop all tables where table name like '%%' ?

anbu1984 — Wed, 26 Nov 2014 10:32:46 GMT

FOR i = 0 to NoOfTables()

LET vTabNam = TableName($(i));

TRACE '$(vTabNam)';

If '$(vTabNam)' Like 'C_*' Then

Drop Tables '$(vTabNam)' ;

ENDIF;

NEXT i

Re: qlikview script: Drop all tables where table name like '%%' ?

Wed, 26 Nov 2014 12:47:25 GMT

Hi Anbu,

It works..thanks. One more question though, If I wanted to add another condition to make it like

If '$(vTabNam)' Like 'C_*' and '$(vTabNam)' not Like 'C_D_*' then

How can I do that in Qlikview? I guess there is no NOT LIKE operator in Qlikview so what would be the alternative?

Shah

Re: qlikview script: Drop all tables where table name like '%%' ?

anbu1984 — Wed, 26 Nov 2014 12:50:53 GMT

Not('$(vTabNam)' Like 'C_D_*')

Left('$(vTabNam)',1,4) <> 'C_D_'

Re: qlikview script: Drop all tables where table name like '%%' ?

perumal_41 — Wed, 26 Nov 2014 13:10:27 GMT

Try like below

not

('$(vTabNam)' like

'C_D*' ) and

'$(vTabNam)' like

'C_*' Then

Drop

Tables

'$(vTabNam)' ;

ENDIF

;

NEXT