topic Re: Rename in 11.20 SR6 in QlikView

Rename in 11.20 SR6

stabben23 — Wed, 07 May 2014 07:30:31 GMT

Hi,

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

Re: Rename in 11.20 SR6

tombombadil — Wed, 07 May 2014 07:37:25 GMT

Hi,

'as' works without a flaw here.

Can you provide the whole script for the specified table?

BR,

Tom

Re: Rename in 11.20 SR6

selvakumarsr — Wed, 07 May 2014 07:40:27 GMT

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

Re: Rename in 11.20 SR6

kaushiknsolanki — Wed, 07 May 2014 07:43:15 GMT

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

Re: Rename in 11.20 SR6

stabben23 — Wed, 07 May 2014 07:43:55 GMT

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.

Re: Rename in 11.20 SR6

stabben23 — Wed, 07 May 2014 07:49:19 GMT

Hi,

This is a preceding Load and it shold works everytime.

Re: Rename in 11.20 SR6

stabben23 — Wed, 07 May 2014 07:52:34 GMT

Re: Rename in 11.20 SR6

tombombadil — Wed, 07 May 2014 07:59:04 GMT

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

its_anandrjs — Wed, 07 May 2014 08:08:14 GMT

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.

Re: Rename in 11.20 SR6

stabben23 — Wed, 07 May 2014 08:12:18 GMT

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