topic Re: Branch code in Connectivity & Data Prep

Branch code

Luka-enterprise — Mon, 02 Nov 2020 21:15:18 GMT

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

Re: Branch code

lironbaram — Tue, 03 Nov 2020 08:21:00 GMT

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/MappingFunctions/ApplyMap.htm
your real challenge will be to decide which fields of branch you are connecting.

Re: Branch code

Luka-enterprise — Tue, 03 Nov 2020 08:33:36 GMT

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.