Link multiple tables

[danimarc12]

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!

[Qlik1_User1]

@danimarc12 Share the datamodel screen print.

[stevejoyce · Accepted solution]

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.

[danimarc12]

[danimarc12]

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.