topic Re: How to connect multiple tables with the same Key in App Development

How to connect multiple tables with the same Key

Derek_T — Wed, 22 Jun 2022 19:30:42 GMT

Hi !

I'm new to Qlik and using the Script Editor to import data and connect tables.
I have several tables with the same ID:

Table 1: ID
Table 2: ID
Table 3: ID
...

I'd like to connect to connect Table 2, 3... to Table 1 using ID.
But Qlik creating the link automatically how do I avoid creating link between tables 2 and 3... ?

I could always have duplicate columns ID in Table 1 (one for each of the other tables) but that does not seem like a very clean solution.

Thanks !

Re: How to connect multiple tables with the same Key

Vegar — Wed, 22 Jun 2022 19:42:34 GMT

Qlik Sense will associate all data based on field names. As long you have the same field name in the three you will have an association between your tables

If the ID is the same ID in the three, then it might not be a bit issue connecting the three. If you still need to separately the three then you could consider renaming the fields.

Table1: Load ID as ID2, ID as ID3, ... From T1;

Table2: Load ID as ID2, ... From T2;

Table3: Load ID as ID3, ... From T3;

Re: How to connect multiple tables with the same Key

Derek_T — Wed, 22 Jun 2022 19:48:07 GMT

Thanks, so if I understand correctly you don't have a choice but duplicating the reference column in the "Master" table to use unique ID name for each tables.

In the case of a Master Calendar for instance I would have:
Date, Date Table1, Date Table2, Date Table3... so each of the tables (1,2,3...) connect to the Master Calendar without creating link between each others.

I'm just going to keep the question open for while see f other suggestions come in.

Thanks !

Re: How to connect multiple tables with the same Key

rwunderlich — Wed, 22 Jun 2022 20:03:59 GMT

The classic way to approach the multiple Date > MasterCalendar issue is to use a link table. See

Qlikview Cookbook: Tutorial - Using Common Date Dimensions https://qlikviewcookbook.com/recipes/download-info/tutorial-using-common-date-dimensions/

-Rob

Re: How to connect multiple tables with the same Key

Derek_T — Thu, 23 Jun 2022 12:26:29 GMT

Thanks ! I'm still new to Qlik and we use company licences, so I cannot necessarily upload file downloaded on internet , would you have an example of the kind of script used to build such a connection please ?