Normalize user company information

[KB15]

I'm looking for a solution to poorly entered company data for users. We have lots of variations of corporate company names (we have many companies) so that we can get better reporting. I've looked at the normalization plugin but I'm not sure it can do that on the user table level since it's a reference field.

If we have 3 variations on the name and want to make it just Acme Company?

• Acme Company
• Acme Companies
• Acme Company1

How would or could this work on the company table? Would it merge the company together or would I end up with 3 entries of Acme Company?

Obviously, we could modify the import source however I don't think that's a possibility.

[Ashutosh Munot1]

HI,

Try using normalisation on Company Table Name field.

Thanks,
Ashutosh

[KB15]

I tried it on the company name field but it just changes the record name. I would also need to merge the records so that one one record appears and not 3 of the same name. Would this tool work for that?

[KB15 · Accepted solution]

I had to use the Coalesce option to merge records to a single record. Just an observation, the product documentation, currently, as the jobs listed above the configuration portion which was a little confusing.