Rename in 11.20 SR6

[stabben23]

Hi,

I have discover that the us of as (rename) dont works in 11.20 SR6 someone else?

[tombombadil]

Hi,

'as' works without a flaw here.

Can you provide the whole script for the specified table?

BR,

Tom

[selvakumarsr]

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

[kaushiknsolanki]

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]

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]

Hi,

This is a preceding Load and it shold works everytime.

[stabben23]

[tombombadil]

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

[its_anandrjs]

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]

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