Clay Icon

Troubleshooting Data Parsing Issue Between Company and People Tables

ยท
ยท

Hi, I can't figure out why, but I have a table that is not parsing a column from the company table to the people table properly. The data seems to just not come through at all

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    If company data isn't properly showing up in your people table, you'll need to rerun the lookup in your people table to refresh the data. This is done through the "Lookup Single Row in Other Table" column (marked with the Clay logo) in your people table.When you add new company data or make changes to your company table, these updates won't automatically sync to your people table. Simply rerun the lookup column to pull in the latest enriched company data and ensure you have the most up-to-date information. Sources: Find People [Clay 101] - Clay University Enrich People (Waterfalls) [CRM Enrichment] - Clay University

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Is that what you were looking for?

  • Avatar of Jeff T.
    Jeff T.
    ยท
    ยท

    That still didn't work

  • Avatar of Jeff T.
    Jeff T.
    ยท
    ยท

    it's showing 0 for a value that has other values

  • Avatar of Jeff T.
    Jeff T.
    ยท
    ยท

    that's the problem

  • Avatar of Jeff T.
    Jeff T.
    ยท
    ยท

    the data column is appearing in the "company table data" but it doesn't have the right value

  • Avatar of Jeff T.
    Jeff T.
    ยท
    ยท

    which is weird

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    If you're seeing zeros where you expect values after running a lookup, you can try these steps to resolve the issue:1. Check if the data already exists in your CRM or another Clay table 2. Use the Lookup column feature to pull in the existing data instead of running a new enrichment 3. Watch our CRM Lookup Tutorial for detailed guidance: CRM Lookup Tutorial 4. For looking up data from other tables, you can reference our Data Lookup Tutorial: Data Lookup Tutorial Source: Guide: Ways to Save Clay Credits - Clay University

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Did that answer your question?

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.