Advanced Normalization of Company Names: Simplifying to HCL

is there a a way when using the normalize company name feature to get a little bit more advanced? For example I'd rather have it normalize to just "HCL" rather than HCL America. One word names that drop the second part. Could use GPT for this but wanted to know if there was a way to do it without consuming credits.

6 comments

Stefano
·
·
Hi, thank you for reaching out. One free way to modify the names of companies, especially if this only involves dropping some words, is through the use of " Formulas" enrichment. In order to add a formula column, select "Add Column" and then from the drop-down menu select formulas, as shown below: https://downloads.intercomcdn.com/i/o/w28k1kwz/1249216829/9b0e05270092518553f3f78fbbd4/CleanShot+2024-11-12+at+13_01_31%402x.png?expires=1731437100&signature=da5bd3d39350b7041dd409ad7724035379b3bdc87eb2f07fe725a9e3cb6e7851&req=dSIjH8t%2Fm4ldUPMW1HO4zUXLvhdsucqko266DK98NmW4HZha53XPyRPfV%2FAN%0A7Z7s%0A After selecting this, you'll be able to either use an AI prompt in the first box or JavaScript to instruct Clay on how to process the results from a column. An example of what this looks like is shown below: https://downloads.intercomcdn.com/i/o/w28k1kwz/1249218218/baa8e27caaa1c87e12bec37ab2d9/CleanShot+2024-11-12+at+13_02_13%402x.png?expires=1731437100&signature=fa5d4025b02112a89de651da800cfc9115dd1e331677121926f84e68acfcf2f7&req=dSIjH8t%2FlYNeUfMW1HO4zai%2BKIVPlxzcsNA8L2asNi2kpgk5qzYa2JUXUCbF%0AcCWm%0A In this case, I recommend using the first box to specify what you want Clay to do. Then, click on "Generate Formula," which will create a JavaScript formula for you and show the results that would be generated if the formula were applied. If you're satisfied with the results, simply click "Output Is Correct, Save Formula." The button is shown below: https://downloads.intercomcdn.com/i/o/w28k1kwz/1249224304/2527ae787c8382a8a92700a112a0/CleanShot+2024-11-12+at+13_06_48%402x.png?expires=1731437100&signature=a315ecb31b2fb9e24c9d4d67cc29dca17995f34c5cdf35ed55e3e8cab6ce800c&req=dSIjH8t8mYJfXfMW1HO4zWMS7aRK4NPUePT7Tmj71bfcCnHRo6RlUtxvarGw%0Ax%2FXX%0A For more information on how AI formulas work, I recommend you take a look at this Clay University video, which explains everything in more detail! Please let me know if this helps!
Channeled
APP
·
·
Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.
Hunter D.
·
·
Money
Hunter D.
·
·
this worked
Hunter D.
·
·
thank you
Channeled
APP
·
·
Hi Hunter D.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: