Clay Icon

Issue with 'Write to Table' Enrichment for Lookalike Companies

·
·

Hiya folks, I'm trying to use the 'write to table' enrichment to write a list of lookalike companies to a new table, but I see the following numbered attributes instead of attributes like 'company name' etc per Yash's video tutorial... not sure what I'm doing wrong and any advice would be much appreciated.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    When using the "write to table" feature for lookalike companies, you might see numbered attributes instead of specific field names due to how the raw data is initially formatted. This is normal and can be adjusted. To organize your lookalike data more effectively: 1. Use the "write to table" function 2. Select "New Table" if you don't have an existing one 3. Choose the specific fields you want to include, such as: • Company name • Domain • Similarity score • Company size • Industry • Source lookalike company By selecting these fields, you'll create a more structured and usable format for your lookalike data, replacing the numbered attributes with meaningful column names.

  • Avatar of Tanvi R.
    Tanvi R.
    ·
    ·

    Hey Steve, thanks for reaching out! When you're selecting a list from a column, could you try opening the companies list and then selecting "insert all properties"? This should input the companies list. Once you've selected this list, you can select the company name field to write over. Let me know if this works for you!

    (423 kB)
    Image
  • Avatar of Steve G.
    Steve G.
    ·
    ·

    Thanks Tanvi R. but when I select Insert All Properties I get this error

  • Avatar of Steve G.
    Steve G.
    ·
    ·

    Nevermind, got it working. Thanks! 🙏

  • Avatar of Steve G.
    Steve G.
    ·
    ·

    Not sure about the error though because it ran successfully. Confused me.

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Hey Steve, No worries — I checked your table and the list is added correctly. Now the issue is that the values from the list aren’t all mapped properly. You’ll just need to double-check the mapping to make sure each one is assigned to the right field if you want them to show up as expected. Let me know if you want help reviewing the mapping!

    (8754 kB)
    Image
  • Avatar of Channeled
    Channeled
    APP
    ·
    ·