Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey guys,
I am a newbie to qlikview. Could anyone tell me how I can change the table name in edit script?
Many thanks
Hi,
NewTableName:
Load statement | Select Statement
Table1:
Load * from Prod;
or
Table1:
Load *;
Select * from Prod;
Thanks,
Jagan
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.
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
...or
Rename table [OriginalTableName] to [NewTableName] ;
Use
Rename Table OldTableName NewTableName;