topic tmap Lookup - how to do lookup with same fields and same table but multiple fields on same id fields in Talend Studio https://community.qlik.com/t5/Talend-Studio/tmap-Lookup-how-to-do-lookup-with-same-fields-and-same-table-but/m-p/2356069#M121684 <P>FYI- @Aiming Chen​&nbsp;</P><P>Is this the correct way to do lookup on id with multliple fields of same table or do I have to take the same table input multiple times and do lookup.</P><P>​</P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000ly6yKAAQ.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/139847iF57560966CAAAB98/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000ly6yKAAQ.png" alt="0695b00000ly6yKAAQ.png" /></span></P> Fri, 15 Nov 2024 21:30:54 GMT Sbxr80 2024-11-15T21:30:54Z tmap Lookup - how to do lookup with same fields and same table but multiple fields on same id fields https://community.qlik.com/t5/Talend-Studio/tmap-Lookup-how-to-do-lookup-with-same-fields-and-same-table-but/m-p/2356069#M121684 <P>FYI- @Aiming Chen​&nbsp;</P><P>Is this the correct way to do lookup on id with multliple fields of same table or do I have to take the same table input multiple times and do lookup.</P><P>​</P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000ly6yKAAQ.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/139847iF57560966CAAAB98/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000ly6yKAAQ.png" alt="0695b00000ly6yKAAQ.png" /></span></P> Fri, 15 Nov 2024 21:30:54 GMT https://community.qlik.com/t5/Talend-Studio/tmap-Lookup-how-to-do-lookup-with-same-fields-and-same-table-but/m-p/2356069#M121684 Sbxr80 2024-11-15T21:30:54Z Re: tmap Lookup - how to do lookup with same fields and same table but multiple fields on same id fields https://community.qlik.com/t5/Talend-Studio/tmap-Lookup-how-to-do-lookup-with-same-fields-and-same-table-but/m-p/2356070#M121685 <P>Hi @Sushil Singh​&nbsp;</P><P>​</P><P>If both Indicator__c and Donor__c can be used to join with the Id column on the lookup table, then you'll need to add a second lookup using the same input as row8.</P><P>​</P><P>Then, for each lookup you use a different column from the main row.</P> Tue, 08 Aug 2023 01:19:17 GMT https://community.qlik.com/t5/Talend-Studio/tmap-Lookup-how-to-do-lookup-with-same-fields-and-same-table-but/m-p/2356070#M121685 anselmopeixoto 2023-08-08T01:19:17Z