Join and Case sensitive

Mees · October 19, 2010 8:34PM

Hi there,

My join in DM joins two fields whereby values are equal, except for the fact that in one file it is all lower caps and in the other it is both small caps and caps.
Example: "Omniscope" should join with "omniscope" and "omniScope"
I assumed I should use the functions Accent sensitive and Case sensitive in the Merge/Join block, but unfortunately this doesn't work like this.

Can you please advise?
Thanks
Arjan

steve · October 20, 2010 10:01AM

You want case insensitive (i.e. do not tick the box), no?

Mees · October 20, 2010 10:21AM

HI Steve, it needs to be case insensitive indeed.
Unticking the checkboxes did not join the two values.
I am using build 405 64bit

steve · October 20, 2010 4:00PM

Thanks for posting. This has been fixed in tonight's build.

Mees · October 21, 2010 10:55AM

Thanks Steve. Just downloaded new build and it works.

Welcome!

Categories

Ideas Parade

Tagged