Clay Icon

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?

  • Avatar of Channeled
    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.

  • Avatar of kushagra
    kushagra
    Β·
    Β·
    • 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

  • Avatar of kushagra
    kushagra
    Β·
    Β·

    guess that's what you meant too haha

  • Avatar of Ariel L.
    Ariel L.
    Β·
    Β·

    kushagra yep - thanks!

  • Avatar of LuisArturo
    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)
    Image
  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·