idea Qlik Compose: Join multiple fields from the same table and same join conditions once rather than creating one lookup for each field in Suggest an Idea https://community.qlik.com/t5/Suggest-an-Idea/Qlik-Compose-Join-multiple-fields-from-the-same-table-and-same/idi-p/1892384 <P>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.&nbsp;</P> <P>&nbsp;</P> <P>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.&nbsp;&nbsp;</P> Mon, 14 Feb 2022 07:46:25 GMT aspence 2022-02-14T07:46:25Z Re: Qlik Compose: Join multiple fields from the same table and same join conditions once rather than creating one lookup for each field - Status changed to: Open - On Roadmap https://community.qlik.com/t5/Suggest-an-Idea/Qlik-Compose-Join-multiple-fields-from-the-same-table-and-same/idc-p/1914187#M9157 <P>Thankyou for the suggestion.&nbsp; This feature (re-use of lookups within a mapping) will be added to the roadmap.&nbsp;</P> Mon, 04 Apr 2022 21:23:57 GMT https://community.qlik.com/t5/Suggest-an-Idea/Qlik-Compose-Join-multiple-fields-from-the-same-table-and-same/idc-p/1914187#M9157 TimGarrod 2022-04-04T21:23:57Z From now on, please track this idea from the Ideation por... https://community.qlik.com/t5/Suggest-an-Idea/Qlik-Compose-Join-multiple-fields-from-the-same-table-and-same/idc-p/2119181#M16459 <P>From now on, please track this idea from the Ideation portal.&nbsp;</P><P><STRONG><A title="Link to new idea" href="https://ideation.qlik.com/app/#/case/275046" target="_blank" rel="noopener">Link to new idea</A></STRONG></P><P>Meghann</P><P data-unlink="true"><EM>NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you <STRONG>only</STRONG> see 1 tab with the login page, please try clicking this link first: <STRONG><A title="Authenticate me!" href="#" target="_blank" rel="noopener">Authenticate me!</A></STRONG>&nbsp;t</EM><EM>hen try the link above again. Ensure pop-up blocker is off.</EM></P> Mon, 18 Sep 2023 17:44:54 GMT https://community.qlik.com/t5/Suggest-an-Idea/Qlik-Compose-Join-multiple-fields-from-the-same-table-and-same/idc-p/2119181#M16459 Meghann_MacDonald 2023-09-18T17:44:54Z Re: Qlik Compose: Join multiple fields from the same table and same join conditions once rather than creating one lookup for each field - Status changed to: Closed - Archived https://community.qlik.com/t5/Suggest-an-Idea/Qlik-Compose-Join-multiple-fields-from-the-same-table-and-same/idc-p/2119182#M16460 Mon, 18 Sep 2023 17:44:56 GMT https://community.qlik.com/t5/Suggest-an-Idea/Qlik-Compose-Join-multiple-fields-from-the-same-table-and-same/idc-p/2119182#M16460 Ideation 2023-09-18T17:44:56Z