Can the Normalization Data Services plugin update the Name field on the Companies [core_company] table?

[Mitch7]

I have been exploring the idea of normalizing the Name field on the Companies [core_company] table in ServiceNow. Effectively what we want to do is import data from an external source, such as an Excel, that has a list of Vendors on it. This list however contains many of the same Vendors but with variant names, such as AT&T Mobility, AT&T Wireless, etc. What we want to accomplish is when we load and import this data we avoid any records on the Companies table to have a variant name and be normalized to a more standard one. For example: An entry with the Name field as AT&T Mobility will automatically be changed to AT&T.

I have been exploring the Normalization Data Services plugin, but have yet to get it to achieve this. I have been able to use the Field Normalization plugin to accomplish this however. The downside is that we would need to define a lot of data in regards to the standard Vendor names when importing.

I know that the Normalization Data Services plugin normalizes fields in other tables that reference the Companies table, but I was hoping it would also normalize the Companies table itself. Anyone have any ideas?

[Wildbeach]

Hi, we intend to use this, from my point of view it does exactly what it says it should, and your last question might be answered in this KB: https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0957144.

"The normalization job does not delete records. It only updates “manufacturer” or “publisher” fields on the records to their normalized values. So there should never be any record loss here."