Forum Discussion
How to make a Merged Query non case sensitive?
Hello I joined two tables with Merged Query using Left Outer join. It appears it only matches case-sensitive data and it omits all the non case-sensitive matches. How can I fix this? ...
You can try to do a fuzzy match when you are doing the Merged Query
Make sure to set
Similarity Threshold = 1.0 (so you get exact matches)
Ignore Case = Check
As always, make sure to test the matched results before pushing to prod.
Similarity Threshold Indicates how similar two values need to be in order to match. The minimum value of 0.00 causes all values to match each other. The maximum value of 1.00 only allows exact matches. The default value is 0.80.
Ignore case Indicates whether text values should be compared in a case sensitive or insensitive manner. The default behavior is case insensitive, which means case is ignored.