topic Re: Link multiple tables in App Development

Link multiple tables

danimarc12 — Wed, 01 Dec 2021 11:55:35 GMT

Hello everyone!

I have an issue with my app. I need to connect 3 tables of the product classification. Reparto --> Gruppo --> Sottogruppo.

with my Fact Table:

but I know I can't connect the tables with 2 or more keys 'cause I'm gonna create a Syntetich keys. How can I solve my problem? Any suggestion?

Thank you all!

Re: Link multiple tables

Qlik1_User1 — Wed, 01 Dec 2021 12:26:16 GMT

@danimarc12 Share the datamodel screen print.

Re: Link multiple tables

stevejoyce — Wed, 01 Dec 2021 13:08:43 GMT

for multiple join keys, create composite key (ex. codReparto & '|' & codSotGruppo as %Reparto_SotGruppo). Drop component fields from one of your tables and just keep in one table, but composite key in both tables. You can also add AutoNumber %Reparto_SotGruppo; at the end of the script as well.

Re: Link multiple tables

danimarc12 — Wed, 01 Dec 2021 18:00:13 GMT

Re: Link multiple tables

danimarc12 — Wed, 01 Dec 2021 18:04:42 GMT

Basically each codArticolo belongs to a codSotGruppo which belongs to a codGruppo which belongs to a codReparto. I have each cod- in my fact table but I want to display, ofc, in my App the Names of each classification.

And I have, for examples:

inside codReparto:1 = codGruppo1, codGruppo2.

inside codReparto:2 = codGruppo1, codGruppo2.

So I need to link each item for codSotGruppo, codGruppo and codReparto.