topic Re: Join two tables in Qlik Compose in Qlik Compose

Join two tables in Qlik Compose

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

📍 Hello everyone,

How can i join two tables in Qlik Compose ?

Re: Join two tables in Qlik Compose

Nanda_Ravindra — Mon, 13 Jun 2022 16:23:10 GMT

@Ben_yedder There are different methods to accommodate this in Compose.

There is a whitepaper posted on community.qlik.com that discusses the modeling approach and benefits to CDC / incremental ETL and can be found here - https://community.qlik.com/t5/Qlik-Compose-for-Data-Warehouses-Documents/Modeling-Real-time-Data-War...

Option 1 - Use a LOOKUP in the ETL Mapping. The Lookup will perform a JOIN and allow you to map a column from the lookup table and bring it into the target entity in the DWH Model.
Note that when running CDC workloads - changes to the lookup table do not drive the ETL. (Only changes to the table defined as the mapping source are seen).

Option 2 - Leave the data in a normalized state in the model. and use the data mart layer to denormalize the data into the dimension/fact table.

Please check the post below which shows with an example.

https://community.qlik.com/t5/Qlik-Compose-for-Data-Warehouses/Join-two-tables-in-compose/td-p/1745044

Thanks,

Nanda

Re: Join two tables in Qlik Compose

Ben_yedder — Mon, 13 Jun 2022 16:31:22 GMT

Can you explain more please, with pictures because i think that i don't have the same options as you.

Thanks.

Re: Join two tables in Qlik Compose

Nanda_Ravindra — Mon, 13 Jun 2022 16:54:18 GMT

@Ben_yedder what version of Compose are you running?

The white paper I shared explains it to you in detail. Please check out this link and download and review the information. If you need further assistance, please open a case with support and we will assist you with that.

https://community.qlik.com/t5/Qlik-Compose-for-Data-Warehouses-Documents/Modeling-Real-time-Data-Warehouses-in-Compose/ta-p/1724153

Re: Join two tables in Qlik Compose

Ben_yedder — Mon, 13 Jun 2022 17:08:17 GMT

The version of august 2021

Re: Join two tables in Qlik Compose

Nanda_Ravindra — Tue, 14 Jun 2022 14:10:07 GMT

@Ben_yedder August 2021 should have the option that's described in the white paper. So, please review and document and if you need further assistance, please open a case with support and we will assist you with that.

Thanks,

Nanda