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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to use alias function in in line 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

5 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

MyExampleTable:

Load A, B, C as D; // alias C as D

Load * inline [

A, B, C

1,2,3

4,5,6

];


talk is cheap, supply exceeds demand
Not applicable
Author

thanks gysbert send another example how to use alias () and Rename ()?

its_anandrjs
Champion III
Champion III

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

];

Not applicable
Author

thanks anand

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

See this blog post: How to Rename Fields


talk is cheap, supply exceeds demand