Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to create alias function in inline table in qlikview?

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

4 Replies
swuehl
MVP
MVP

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

Not applicable
Author

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.

swuehl
MVP
MVP

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

];

Not applicable
Author

thanks swuehi