Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
zhbuyiqlik
Contributor II
Contributor II

Assign Different Alias for different Tables

I have 3 tables: A, B, and C.   Each has a field called City.  I wanted to assign City from A as A.City, B as B.City and C as C.City;

I tried the following code, but the Qlik Aliased all cities as A.City.   Is there a way to limit the range of Alias?

[table A]:

Alias [City] as A.City;

SQL Select * from A;

[table B]:

Alias [City] as B.City;

SQL Select * from B;

[table C]:

Alias [City] as C.City;

SQL Select * from C;

Labels (1)
1 Reply
Anil_Babu_Samineni

You can remove Alias everywhere it will work (Ex [City] as C.City)

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)