Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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.