Will the fuzzy grouping task match a null value to an empty string (or spaces)? I've got 5 columns I'm matching on, and one of them may be null for certain rows but an empty string for others. Given the 4 other columns may match, will this difference stop similar columns being grouped together?
(Someone's modified my grouped data since it was deduped, which takes a while, and I'm hoping for a quick answer on this).
Thanks in advance.
Ben
Not sure, but building a quick package and adding a data viewer should give you the answer.I would hope that a NULL wouldn't match to spaces...
Couldn't you run an update query to "fix" the data?|||
Computer says "no"
<cough>
No duplicate matching between null and empty string/spaces, as you suspected. Thanks for the idea of the quick test - seems obvious in retrospect, if only it had been beforehand Unfortunately I can't fix the data, other than rerunning the grouping task, but good to know the source of the problem - thanks Phil!
No comments:
Post a Comment