Malformed Data often sneaks into our CRMs undetected. In this session we will take a closer look at how to identify malformed data in your CRM and provide an overview of how to use DemandTools for remediation. Check below for some of the Record Sele...
Hi All,
It was great seeing everyone turn out for our first Identifying Malformed Data webinar! I was excited to show you how to align your search with your Assess module results, but more importantly, find all that dirty data!
Here is what I conditi...
Hi Everyone,It was a pleasure hosting the Modify: Using Advanced Formulas for Data Standardization webinar today. I hope you all found it useful!I'm going to include all formulas that I used as examples during the session. I will also provide the l...
Huge thanks to everyone who attended today's training on Using Formulas for Advanced Data Standardization. Below are a few additional resources that were referenced during the training. Also, I am going to add a comment with samples of the formulas ...
Huge thanks to everyone who attended today's training on Using Formulas for Advanced Data Standardization. Below are a few additional resources that were referenced during the training. Also, I am going to add a comment with samples of the formulas ...
Here is what I conditioned on in Tune to find fields that do not contain vowels. As a note, we could also exclude the acronyms found in the Account Name field by using four underscores and the operator of "like."
Identifying malformed US zip codes...
Hi @stevecottrell,I'm so happy to hear that it worked!Do you know what the character limit is for a pipeline delimited list?I don't have the exact number but tested 50k characters and it worked.I checked the alpha clean option for this match but can ...
Hi @stevecottrell ,I did some testing and I think this would work for you. DemandTools 5.x does not have a way to match a cell to a field that "contains" a word/string.We can, however, create a pipeline delimited list of every account name in your f...
Hi @katiepelly ,
Are you using Custom Merge in the Merge Options are of the Dedupe preview screen? I would open a Support ticket by clicking here:https://knowledge.validity.com/s/contactsupport?language=en_USRegards,
Hi All,
We discussed this on What is DemandTools Expert Office Hours? today. We're going to have Mike setup a custom scoring on all address fields. He is going to use, for example, "Street Address is populated equals 1 point". He will be doing the...