Assign Different Alias for different Tables

zhbuyiqlik — Sat, 16 Nov 2024 17:39:36 GMT

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;

Re: Assign Different Alias for different Tables

Anil_Babu_Samineni — Thu, 31 Dec 2020 19:44:33 GMT

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