Qlik Compose: Join multiple fields from the same table and same join conditions once rather than creating one lookup for each field
In the scenario where you want to join multiple fields from one table into another using the same join conditions, you would solve this in SQL by using one join condition. However, in compose, if you create one lookup for each field, it will generate the same join condition for each lookup. This is very inefficient in terms of computational power.
I therefore suggest the possibility to add a join condition once, and then selecting the fields you want to join in (lookups) without recreating the join condition for each lookup field.
NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.