Branch code

[Luka-enterprise]

I connected my Qlik server to my rental DBS.

I have 1 table with branch codes:

1 | Airport 1
2 | Airpot 2....

I have tables:

Fleet with columns: Check out branch code, Check-in Branch code
Agreements with columns: Agreement check out branch code, Agreement chench in-branch code
Invoice: Branch invoice code
Maintainance: Branch code
...

In basis there are many occasions where branch code is needed to map.

What is the best way to map it? Shall I create a link to each table of Branch code and create  relation to branch code or?

Thanks

[lironbaram]

the best way to map code to name will be using applymap function :
https://help.qlik.com/en-US/sense/September2020/Subsystems/Hub/Content/Sense_Hub/Scripting/MappingFu...
your real challenge will be to decide which fields of branch you are connecting.

[Luka-enterprise]

But I don't wanna "hard code" it as in my DBS are branches and for example new branch with code 95 is opened I don't wanna map it again in code - I have it on DBS and I wanna use it on every instance where I have Branch code.