topic Re: Dropping Table in script in QlikView

Dropping Table in script

Fri, 03 Apr 2015 06:02:07 GMT

Hi,

I want to create a dynamic environment, where the schema and table name keeps on changing.

Issue:

I want to drop a table during partial reload. !

Can this be done ?

Can we write something like:

If(Tables Exists !)

{ Drop it! }

Else

{ Proceed }

Thanks & Regards

Swapneel

Anonymous — Fri, 03 Apr 2015 06:08:17 GMT

Try defining a variable for your table name

pokassov — Fri, 03 Apr 2015 06:10:47 GMT

Hello!

You can use this

if not isnull(TableNumber('your table name')) then

Sergey

Fri, 03 Apr 2015 06:41:52 GMT

Hey Sergey,

Didnt follow you exactly, can you please elaborate. ?

Thanks

Swapneel

pokassov — Fri, 03 Apr 2015 06:59:01 GMT

Sure

if you have table with name "tab" and want to delete it, than script will be

if not isnull(TableNumber('tab')) then

{ Drop it! }

Else

{ Proceed }

end if;

Fri, 03 Apr 2015 07:11:19 GMT

Thanks Sergey
It works

Thanks a ton