topic Re: how to create alias function in inline table in qlikview? in QlikView

how to create alias function in inline table in qlikview?

Fri, 25 Apr 2014 17:30:55 GMT

hi guys,

I want to create alias function in qlikview.I do not know how to create alias function in qlikview ,please tell me out with examples.

Regards:

madhu

Re: how to create alias function in inline table in qlikview?

swuehl — Fri, 25 Apr 2014 17:52:39 GMT

Sorry, I don't understand what you want to achieve. Could you give an example what this function should do?

Re: how to create alias function in inline table in qlikview?

Fri, 25 Apr 2014 18:02:52 GMT

ok swuei.

I created INLINE table like this

Load * Inline

[ id ,Fname,Lname

1 , john, david

2,james,jacob

3.jaya,lalitha

];

the above inline table I want to change field names like this (Id as empid,fname as firstname) .I need to use alias function in this table ,plea tell me out.

Re: how to create alias function in inline table in qlikview?

swuehl — Fri, 25 Apr 2014 18:08:50 GMT

Sorry still not get it, you are already aliasing correctly in your answer, just use...

Load id as empid, Fname as firstname, Lname Inline

[ id ,Fname,Lname

1 , john, david

2,james,jacob

3.jaya,lalitha

];

edit: or just rename the field names of your inline table directly:

Load * Inline

[

empid ,firstname, Lname

1 , john, david

2,james,jacob

3.jaya,lalitha

];

Re: how to create alias function in inline table in qlikview?

Fri, 25 Apr 2014 18:18:35 GMT

thanks swuehi