Advanced Normalization of Company Names: Simplifying to HCL | Clay

Advanced Normalization of Company Names: Simplifying to HCL | Clay

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!
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: