Discussion Board for collaboration on QlikView Scripting.
I have discover that the us of as (rename) dont works in 11.20 SR6 someone else?
'as' works without a flaw here.
Can you provide the whole script for the specified table?
It Working fine..Are you reloading it after changing the Column Alias name?
If you are using the script you have shown for getting data from database, meaning if this is a SQL script then kindly dont use the "As" key word, instead just keep one space and it will work.
Hi, yes ofcourse, I have build the application in 11.20 SR2 with a lot of alias, but yesterday we upgrade to 11.20 SR6.
All old alias was there and works fine, but when I try to add a new table into the model and use alias it dosent works.
This is a preceding Load and it shold works everytime.
Tested it with preceding loading a wildcard SQL statement and it works for me with SR6.
Maybe there is a problem, because you created the QVW with SR2.
Just try to copy and paste the whole script into a new QVW file.
Nevertheless, you should open a ticket at Qliktech support.
Try to write like two alias name and check
CorrespondenceType as TypeID,
Details as test
and check the two fields create with same fields or not.
Doesent work either, even if i does it shouldent work like that.