Join two tables in Qlik Compose

[Ben_yedder]

📍 Hello everyone,

How can i join two tables in Qlik Compose ?

[Nanda_Ravindra · Accepted solution]

@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/17450...

Thanks,

Nanda

[Ben_yedder]

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

Thanks.

[Nanda_Ravindra · Accepted solution]

@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-War...

[Ben_yedder]

The version of august 2021

[Nanda_Ravindra · Accepted solution]

@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