Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
stabben23
Honored Contributor

Rename in 11.20 SR6

Hi,

I have discover that the us of as (rename) dont works in 11.20 SR6 someone else?2014-05-07_0927.png

2014-05-07_0928.png

Tags (5)
9 Replies
tombombadil
New Contributor III

Re: Rename in 11.20 SR6

Hi,

'as' works without a flaw here.

Can you provide the whole script for the specified table?

BR,

Tom

selvakumarsr
Contributor

Re: Rename in 11.20 SR6

It Working fine..Are you reloading it after changing the Column Alias name?

Re: Rename in 11.20 SR6

Hi,

     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.

Regards,

Kaushik Solanki

stabben23
Honored Contributor

Re: Rename in 11.20 SR6

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.

stabben23
Honored Contributor

Re: Rename in 11.20 SR6

Hi,

This is a preceding Load and it shold works everytime.

2014-05-07_0946.png

stabben23
Honored Contributor

Re: Rename in 11.20 SR6

2014-05-07_0951.png

tombombadil
New Contributor III

Re: Rename in 11.20 SR6

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.

BR,

Tom

Re: Rename in 11.20 SR6

Try to write like two alias name and check

Load

CorrespondenceType,

CorrespondenceType as TypeID,

Details,

Details as test

From Location;

and check the two fields create with same fields or not.

stabben23
Honored Contributor

Re: Rename in 11.20 SR6

Doesent work either, even if i does it shouldent work like that.