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
MyExampleTable:
Load A, B, C as D; // alias C as D
Load * inline [
A, B, C
1,2,3
4,5,6
];
thanks gysbert send another example how to use alias () and Rename ()?
You can do aliasing like this way
QUALIFY *;
Table1:
LOAD * Inline
[
X,Y,Z
1,2,3
];
And
Table1:
LOAD X as ID, Y as Name, Z as City
LOAD * Inline
[
X,Y,Z
1,John,Paris
];
thanks anand
See this blog post: How to Rename Fields