Hi Nidhi Patel ,
It would be really great if you will explain the term "Role attribute " ,because it seems the word is being used in different industries with different meaning .And what i understand is you are having Destination and Origin airport id in one table and in another table you have Airport id and airport name and you want to get origin and destination airport name .
If I am not wrong , you can just join these two tables and you will get what you are looking for .
If i missed something , please attach your twbx file or sample data .
I have Microstrategy tool knowledge where i know how to handle Attribute role.
you can refer below link to understand what exactly role attribute is-
My intent of this question is to understand how is thing thing handled in Tableau.
Ok ,So the first thing is yes you can handle it by creating alias .The same way you have handled it in MicroStrategy developer schema . But one more thing , you cant get all functionalities in tableau but you will definitely get a workaround .
I don't have any hands on experience on MicroStrategy tool but checked it now and its interesting .Definitely will give a try.