Automating Deletion of Incorrectly Identified ICP Companies

Hey Guys My claygent made a mistake in identifying companies as ICP Then those companies were written to two other tables since this is how the flow was planned I know how to find those companies in the other table by doing a look up but is there a way to automatically delete them? Or is it going to be a matter of filtering them and just delete all these lines?

6 comments

Channeled
APP
·
·
Unfortunately, there's no automatic way to delete companies incorrectly identified as ICP from multiple tables. You'll need to manually filter and delete these entries. Here's how you can approach this: 1. In the original table, use the deduplication feature to identify the incorrect companies. 2. For the other tables, use our "write to table" feature to transfer the correct data. To clean up company names before transferring, you can use our "Normalize Company Names" function: 1. Go to the enrichment panel and find the "Tools" section. 2. Select "Normalize Company Names." 3. Choose the company name column as input. 4. Run the action across your rows. This will help ensure consistency when filtering and transferring data to other tables.
Source: Data Cleaning + Normalization [Automated Inbound] - Clay University
kushagra t.
·
·
lookup in original companies table to find the ones which are bad fit
add a column post identification of bad fit companies to demarcate them in the original companies table
now do a lookup in the ICP table add the bad fit identification column to the ICP table from the new lookup
filter and delete
kushagra t.
·
·
guess that's what you meant too haha
Ariel L.
·
·
kushagra t. yep - thanks!
🙏1
LuisArturo
·
·
Hey there Ariel thanks for reaching out and appreciate you jumping in Kushagra! Do you mind sending the link (url) to the table so we can take a look?
(52 kB)
1
Channeled
APP
·
·

Automating Deletion of Incorrectly Identified ICP Companies | Clay