Join or concatenate 7 fact tables (and their dimensions)

MichelLalancette — Tue, 15 Jun 2021 18:53:12 GMT

Hi,

We have 7 fact tables revolving around the same subject.

Together, they form a sort of "snowflake" fact tables schema.

There is a "base" fact table and the other tables have a many-to-many relationship with it.

I've loaded the data into Qlik and let it do its magic to auto-join the data and while it kinda gives me what I need (without the dimensions), I'd like to move away from a synthetic table.

Normally I'd try concatenating the tables together but in this case, I wasn't getting the result I wanted.

I need to keep

Here's the Qlik Data Model:

Qlik Data Model with Synthetic Key

Here's the data in SQL with some samples.

SQL Tables and Data Sample

Here's what I'm looking for:

Result without concatenate

Here's what I'm getting when concatenating the data.Result with concatenate

topic Join or concatenate 7 fact tables (and their dimensions) in App Development

Join or concatenate 7 fact tables (and their dimensions)