Find Duplicates - Ignore a value
Options
Hi,
I am attempting to use the find duplicates module. In one of my unique data fields I have dfound that a dummy value has been used for cases where data is not easily obtainable. Is there a way to direct the matching criteria to ignore this value when trying to match rows?
Column name in Data is 'UniqueID'
TIA.
Tagged:
0
Answers
-
Hi, our usual approach here is to cleanse the data beforehand and remove any information not suitable for matching. You could apply a simple 'if then else' function to replace 'UniqueID' with NULL.
I've attached a .dmx with a function you can use. You'll need to be on version 2.16.9 or later to import it.
2
