tMap lookup: Joining on multiple conditions.

[JayQueue]

Hello,

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?

Like row2.jpegFileName + ".jpg" ||

ow2.jpegFileName + ".JPG" (which doesn't work ofcourse)

[JayQueue · Accepted solution]

Created a new column with

row15.basename.replaceAll("\\..*", "") + "." + StringHandling.DOWNCASE(row15.abs_path.substring(row15.abs_path.length()- 3))