Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello:
When I launch the recharge I get the following error:
General error
The name 'table1' already exists.
rename table [table2] to table1
With QV 11, the recharge is carried out without any problem with the same script
Please, do you know how to solve this error?
Thank you
A table cannot be renamed to an existing name. In QV11, this error was simply ignored and the script carried on. QV12 was updated to treat this as a true error that would stop script execution. An improvement in my opinion.
To "solve" this problem, you can simply remove the statement. In QV11 it was doing nothing so you don't need it in QV12.
-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com
Hi, I think that that's the same than removing the rename table instruction.
I would recomend to follow and solve the error, not just ignore it. Why there is a rename of the table and why already exists a table with that name? should data be concatenated?
A field/table couldn't be renamed into one which exists already to this time. I think there were no changes between QV 11 and 12 or any bugs else something has changed within (the order of) your script and there is really already a table1 when you tries this renaming. A quick check would be to add a:
exit script;
before your renaming-statement and then to open the tableviewer.
- Marcus
I made an exit script and there is no error
That's ok. An now take a look ino the tableviewer - per menu or ctrl + t - and you should see anywhere a table1 and quite probably you could identify which data it contains and where and why it was loaded.
- Marcus
Thank you very much for your help
A table cannot be renamed to an existing name. In QV11, this error was simply ignored and the script carried on. QV12 was updated to treat this as a true error that would stop script execution. An improvement in my opinion.
To "solve" this problem, you can simply remove the statement. In QV11 it was doing nothing so you don't need it in QV12.
-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com
Hello,
It worked for me in the following way:
set ErrorMode = 0;
Rename table1 to table2;
set ErrorMode = 1;
Thank you very much for your help
Hi, I think that that's the same than removing the rename table instruction.
I would recomend to follow and solve the error, not just ignore it. Why there is a rename of the table and why already exists a table with that name? should data be concatenated?