Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
JayQueue
Creator
Creator

tMap lookup: Joining on multiple conditions.

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)

0695b00000Uwuy3AAB.png

Labels (2)
1 Solution

Accepted Solutions
JayQueue
Creator
Creator
Author

Created a new column with

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

View solution in original post

1 Reply
JayQueue
Creator
Creator
Author

Created a new column with

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