topic Re: Drop Unused table in Qlikview in QlikView

Drop Unused table in Qlikview

Smeenakshi23 — Thu, 08 Mar 2018 14:31:29 GMT

Hello,

How to drop unused tabl(s) in Qlikview. I have man unused tables in Qlikview application. Kindly let me know how to delete those

Re: Drop Unused table in Qlikview

niclaz79 — Thu, 08 Mar 2018 14:33:32 GMT

drop table TableName;

Re: Drop Unused table in Qlikview

Smeenakshi23 — Thu, 08 Mar 2018 14:34:31 GMT

wanted to drop multiple tables using loop

Re: Drop Unused table in Qlikview

niclaz79 — Thu, 08 Mar 2018 14:37:16 GMT

Drop tables Table1, Table2; ??

You're not giving much information in order to help out. Above is the script terminology to drop one or more tables. Can you give an example of the script that you are not getting to work?

Re: Drop Unused table in Qlikview

kevinalvino — Fri, 09 Mar 2018 06:36:39 GMT

Hi sowmiya23 ,

Another alternative beside using loop from dropping the table is counting the content of desired dropped table in a variable, checking its content whether it is empty ( if it not use, it means the table even haven't been created ), or there's exist a value inside the table.

Example :

LET vCheck = NoOfRows('table that wants to be checked'); -> this can be coupled with looping

This will count the number of rows inside it, for checking.

For dropping the table :

IF IsNull(TableNumber('table that wants to be checked')) THEN -> table number is the number of table, if not exist then it should be no value returned.

DROP Table 'The table that wants to be checked'; -> if you previously used looping, everytime it loop, it should be changes. Don't know about using the name of the table inside a variable, to make it more flexible.

Dont forget, every time using an IF THEN , close it with

ENDIF;

Not completely sure this will work, but at least the point is, there's a way to check which table is not containing anything, and using expression to drop it.

Hope it's help

Kevin

Re: Drop Unused table in Qlikview

Smeenakshi23 — Fri, 09 Mar 2018 06:56:15 GMT

Thank you.. Let me give a try