Clay Icon

Issue with Enrichment Project: Email Column Overwritten and Data Loss

·
·

I am wondering what happened to my sheet. I was very deep into an enrichment project. I first enriched mobiles, then I pulled any data I could find from those enrichments to help enrich emails. Had to step away for a couple of days and when I came back my email column was empty and it looks like my waterfall someone how got attached to my original email column and overwrote the whole column with the 83 rows I ran, but then blanked out all of the other rows. https://app.clay.com/workspaces/327512/workbooks/wb_3i5HhiNBw953/tables/t_YpKkSHw87Wa3/views/gv_H62pSvNTwsbY

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Hi Micah! It sounds like your email column may have been hidden by a view setting, which can sometimes change how data appears. I recommend checking to see if any view filters or configurations that were previously applied that might be hiding the information in that column. Here’s a helpful article on views in Clay that explains how they work: Clay Views Guide. You can also check by clicking on the column header > run info to see how many credits did this column used

  • Avatar of James Z.
    James Z.
    ·
    ·

    The filters and sorts were all removed.

  • Avatar of James Z.
    James Z.
    ·
    ·

    There was existing imported data that is now gone

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    If filters were applied and then removed, this could cause data gaps, as any filtered data might won't run automatically. This might explain the missing imported data you’re seeing.

  • Avatar of James Z.
    James Z.
    ·
    ·

    I dont think I am explaining myself well.

  • Avatar of James Z.
    James Z.
    ·
    ·

    I believe I tried to pull data from a waterfall colum and instead of pushing it to a new field I pushed it to an existing column which caused it to completely overwrite it, both the fields I enrich and also the fields that werent even in line to be run.

  • Avatar of James Z.
    James Z.
    ·
    ·

    Is there version control to reverse this action Bo (.?

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Understood. Unfortunately, it’s not possible... Let us know if you need more help or if there’s anything else we can assist with.

  • Avatar of James Z.
    James Z.
    ·
    ·

    Bo (. is there a way to do a vlookup from another sheet and match email addresses so I can rewrite all the ones that were erased?

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Yes, you can use the lookup function to match email addresses from another sheet and rewrite the erased ones. Here’s a quick video guide on how to set it up: Lookup Function Guide. Let us know if you need any more help!

  • Avatar of James Z.
    James Z.
    ·
    ·

    Thank you

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Hi James Z.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Thank you so much for sharing your feedback James Z.!

  • Avatar of James Z.
    James Z.
    ·
    ·

    Bo (. the table isnt showing up when I try to target it in this walkthrough. I am logged into the account, just no tables in the drop down.

  • Avatar of James Z.
    James Z.
    ·
    ·
  • Avatar of George D.
    George D.
    ·
    ·

    Hey there Micah, this happens when the APi key needed to run the integration is not properly setup/ Went ahead and reset it for you, can you try running this again and use the option that is called "Clay Key", when it asks you to "Select Clay account"