Clay Icon

Issue with Updating People Table After Adding Company Headcount Variable

Β·
Β·

I updated the company table with a new variable "company headcount". Now when I try to run the whole column in people table, it is not getting updated. I have to run each cell one by one. What am I doing wrong?

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    When you add new company data (like company headcount) to your company table, you'll need to rerun the lookup in your people table to pull in the updated information. Here's how to do it: 1. Find the column in your people table that's linked to the company table (it should have the Clay logo) 2. Rerun this "Lookup Single Row in Other Table" column to refresh the data 3. The new company headcount variable should now be available to pull into your people table You can then extract the company headcount variable by: 1. Click on any cell in the linked company column 2. Hover over the "company headcount" field 3. Select "Add as column" to bring this data into your people table

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    Was that helpful?

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    Looks like you're still looking for help. We're currently outside of our standard office hours (9 AM to 9 PM EST, Monday through Friday), so it may take a little longer for us to respond. If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!

  • Avatar of Sahil S.
    Sahil S.
    Β·
    Β·

    i did it manually for now, when the team is available, i am happy to chat

  • Avatar of Daniel K.
    Daniel K.
    Β·
    Β·

    Hey Sahil, thanks for reaching out! ☺️ I've forced to rerun the column and all the data appears. Sorry for the hiccup! But do let us know if it gives you any trouble again!

  • Avatar of Sahil S.
    Sahil S.
    Β·
    Β·

    Thanks Daniel K. . What was the issue?

  • Avatar of Daniel K.
    Daniel K.
    Β·
    Β·

    It's something on our side. Sometime the company id does not get mapped properly. It happens very rarely! Sorry about this