Reducing Duplicate Joins to the Same Source Table in Data Warehouse Fact
I’m working in Qlik Compose and building a fact table in the Data Warehouse section. The goal is to load a transactional fact at the InvoiceDetail grain, containing only measures and dimensional keys/IDs (no descriptive attributes).
When Compose generates the SQL, I’m seeing multiple LEFT JOINs to the same source table even though the joins all use the same keys
Each join is driven by a different target column mapping, but logically these columns all come from the same source row and could be retrieved with a single join.
Is there a supported way in the Compose UI (specifically in the Data Warehouse section) to reuse a single lookup/join to the same source table across multiple target columns?
