https://community.qlik.com/t5/Talend-Studio/tMap-lookup-Joining-on-multiple-conditions/m-p/2318189#M88555 <P>Created a new column with </P><P><I>row15.basename.replaceAll("\\..*",&nbsp;"") + "." + StringHandling.DOWNCASE(row15.abs_path.substring(row15.abs_path.length()- 3))&nbsp;</I></P> Wed, 17 Aug 2022 11:28:35 GMT JayQueue 2022-08-17T11:28:35Z https://community.qlik.com/t5/Talend-Studio/tMap-lookup-Joining-on-multiple-conditions/m-p/2318188#M88554 <P>Hello,</P><P></P><P></P><P>I'm reading a dir with pictures (read-only) and sometimes it's .jpg and sometimes it's ..JPG. Is it possible to have the lookup check for both versions?</P><P>Like row2.jpegFileName + ".jpg" || </P><P>ow2.jpegFileName + ".JPG" (which doesn't work ofcourse)</P><P></P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000Uwuy3AAB.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/157951iC86CD5296D500434/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000Uwuy3AAB.png" alt="0695b00000Uwuy3AAB.png" /></span></P> Fri, 15 Nov 2024 22:38:26 GMT https://community.qlik.com/t5/Talend-Studio/tMap-lookup-Joining-on-multiple-conditions/m-p/2318188#M88554 JayQueue 2024-11-15T22:38:26Z https://community.qlik.com/t5/Talend-Studio/tMap-lookup-Joining-on-multiple-conditions/m-p/2318189#M88555 <P>Created a new column with </P><P><I>row15.basename.replaceAll("\\..*",&nbsp;"") + "." + StringHandling.DOWNCASE(row15.abs_path.substring(row15.abs_path.length()- 3))&nbsp;</I></P> Wed, 17 Aug 2022 11:28:35 GMT https://community.qlik.com/t5/Talend-Studio/tMap-lookup-Joining-on-multiple-conditions/m-p/2318189#M88555 JayQueue 2022-08-17T11:28:35Z