Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Suggest an Idea

Announcements
This page is no longer in use. To suggest an idea, please visit Browse and Suggest.

Qlik Compose: Join multiple fields from the same table and same join conditions once rather than creating one lookup for each field

aspence
Partner - Contributor II
Partner - Contributor II

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.  

Tags (1)
3 Comments
TimGarrod
Employee
Employee

Thankyou for the suggestion.  This feature (re-use of lookups within a mapping) will be added to the roadmap. 

Status changed to: Open - On Roadmap
Meghann_MacDonald

From now on, please track this idea from the Ideation portal. 

Link to new idea

Meghann

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.

Ideation
Newbie
Newbie
 
Status changed to: Closed - Archived