Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Sorry, I don't understand what you want to achieve. Could you give an example what this function should do?
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.
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
];
thanks swuehi