topic Re: How to change the table name in script? in QlikView

How to change the table name in script?

Fri, 18 Jul 2014 15:34:45 GMT

Hey guys,

I am a newbie to qlikview. Could anyone tell me how I can change the table name in edit script?

Many thanks

jagannalla — Fri, 18 Jul 2014 15:36:45 GMT

Hi,

NewTableName:

Load statement | Select Statement

Table1:

Load * from Prod;

Table1:

Load *;

Select * from Prod;

Thanks,

Jagan

Anonymous — Fri, 18 Jul 2014 15:37:53 GMT

Add one of the following above the load statement.

[Table Name]:

Load

...

From

Sales:

Load

...

From

Note that the [ ] are used when there are spaces in the table name.

simenkg — Fri, 18 Jul 2014 15:41:28 GMT

Your specific question is how to change the table name.

It can simply be done with the line.

Rename table TableName1 to TableName2;

Regards
SKG

Anonymous — Fri, 18 Jul 2014 15:42:21 GMT

...or

Rename table [OriginalTableName] to [NewTableName] ;

MK_QSL — Fri, 18 Jul 2014 15:42:32 GMT

Use

Rename Table OldTableName NewTableName;