Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to change the table name in script?

Hey guys,

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

Many thanks

5 Replies
jagannalla
Partner
Partner

Hi,

NewTableName:

Load statement | Select Statement

Table1:

Load * from Prod;

or

Table1:

Load *;

Select * from Prod;

Thanks,

Jagan

lukesartain
Contributor II
Contributor II

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
Partner
Partner

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

bill_markham

...or

Rename table [OriginalTableName] to [NewTableName] ;

MK_QSL
MVP
MVP

Use

Rename Table OldTableName NewTableName;