Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

How to rename table SALES_TABLE-1 TO SOURCE_TABLE

Hi All

Below is my script :-

RENAME TABLE SALES_TABLE-1 TO SOURCE_TABLE;

I get below error :-

Syntax error in alias statement
RENAME TABLE SALES_TABLE-1 TO SOURCE_TABLE

Below is my table model  , i like to rename the SALES_TABLE-1 TO SOURCE_TABLE :-

 

WHY HET ERROR RENAME.png

5 Replies
agigliotti
Partner - Champion
Partner - Champion

Hi,
could you attach your script to look at?

paulyeo11
Master
Master
Author

Hi Sir

Enclosed the qvw

Qlik1_User1
Specialist
Specialist

In script where you are creating Source,Source_ column, mention the table table on it like below

Table:

Source,
Source_

It will be helpful if you could share the script in text format.

 

paulyeo11
Master
Master
Author

Hi Sir

I already enclosed my QVW.

Paul

Qlik1_User1
Specialist
Specialist

@paulyeo11 Yes , I am not using desktop right now ,so asking for script in text format if possible.