topic rename table in QlikView

rename table

Anonymous — Wed, 21 Nov 2012 16:07:04 GMT

Dear all,

is it possible to rename a table ? In my script I'm trying the following

Rename table My_Table as New_table;

but it doesn't work. The manual gives the same syntax, but it doesn't work properly.

Any suggestions ?

Thanks in advance for your support

swuehl — Wed, 21 Nov 2012 16:17:33 GMT

Try using

Rename table My_Table to New_table;

, this is also what the HELP says, AFAIR.

jeffmartins — Wed, 21 Nov 2012 16:20:00 GMT

Hi bibopipo,

The correct syntax is :

Rename table Tab1 to Tab2;

Regards

Anonymous — Wed, 21 Nov 2012 16:23:03 GMT

Thanks very much!!!

What I've in my HELP is the following: in the first case is mentioned "as" instead "to". Perhaps it's a mistake.

Tab1:

Select * from Trans;

Rename table Tab1 as Xyz;

TabMap:

Mapping load oldnames, newnames from tabnames.csv;

Rename tables using TabMap;

stefan