https://community.qlik.com/t5/Talend-Studio/I-have-to-do-a-left-outer-join-and-I-need-to-write-a-substring/m-p/2365253#M128878 <P>How to write a substring condition for the lookup table key column?</P><P></P><P></P><P>For the source table key Column I can write the condition in the Expression key .</P><P></P><P></P><P>I am using Talend Open Studio 7.3.1?</P> Fri, 15 Nov 2024 23:45:41 GMT Ray0801 2024-11-15T23:45:41Z https://community.qlik.com/t5/Talend-Studio/I-have-to-do-a-left-outer-join-and-I-need-to-write-a-substring/m-p/2365253#M128878 <P>How to write a substring condition for the lookup table key column?</P><P></P><P></P><P>For the source table key Column I can write the condition in the Expression key .</P><P></P><P></P><P>I am using Talend Open Studio 7.3.1?</P> Fri, 15 Nov 2024 23:45:41 GMT https://community.qlik.com/t5/Talend-Studio/I-have-to-do-a-left-outer-join-and-I-need-to-write-a-substring/m-p/2365253#M128878 Ray0801 2024-11-15T23:45:41Z https://community.qlik.com/t5/Talend-Studio/I-have-to-do-a-left-outer-join-and-I-need-to-write-a-substring/m-p/2365254#M128879 <P>Before tMap, add a new column to the look table, this new column has the substring value of lookup column and it will be used as the join key.</P><P>&nbsp;</P><P>Regards</P><P>Shong</P> Wed, 08 Sep 2021 06:35:02 GMT https://community.qlik.com/t5/Talend-Studio/I-have-to-do-a-left-outer-join-and-I-need-to-write-a-substring/m-p/2365254#M128879 Anonymous 2021-09-08T06:35:02Z https://community.qlik.com/t5/Talend-Studio/I-have-to-do-a-left-outer-join-and-I-need-to-write-a-substring/m-p/2365255#M128880 <P>Thanks @Shicong Hong​&nbsp;<span class="lia-unicode-emoji" title=":grinning_face_with_sweat:">😅</span> I didn't think of that,</P><P>It worked</P> Wed, 08 Sep 2021 06:53:25 GMT https://community.qlik.com/t5/Talend-Studio/I-have-to-do-a-left-outer-join-and-I-need-to-write-a-substring/m-p/2365255#M128880 Ray0801 2021-09-08T06:53:25Z