topic Re: Joining Multiple Fact Tables in Data Marts in Qlik Compose

Joining Multiple Fact Tables in Data Marts

TMcC — Fri, 14 Mar 2025 20:49:07 GMT

Is it possible to join and\or left join multiple fact tables from the data warehouse when creating a data mart. For example: Two fact tables have the same ID's and the same Date. Joining or left joining those fact tables will create a single fact table with all the facts for the same ID and Date.

I can work around this using a post loading process. Are there other options?

Re: Joining Multiple Fact Tables in Data Marts

abhijitnalekar — Fri, 18 Mar 2022 15:24:08 GMT

Hi @TMcC ,

Yes, we can join the two fact tables and convert them into one fact table.

Qlik also suggests creating star schema on the model level to retrieve the data quickly and using the above method we can do the same.

I have also applied the same method in my environment and it works perfectly for me.

Re: Joining Multiple Fact Tables in Data Marts

Dana_Baldwin — Thu, 31 Mar 2022 22:52:03 GMT

Hi @TMcC , did @abhijitnalekar comment help? If so, please click the "Accept as Solution" button.

Thank you!

Re: Joining Multiple Fact Tables in Data Marts

kanhomcake — Tue, 19 Nov 2024 15:27:52 GMT

hi @abhijitnalekar ,

Can you please elaborate how you recommend to do it? In my case it is the concatenation of two facts, do I do it in the pre-loading task? or what is the best practice?

Thank you 🙂

Best regards,
kanhomcake