How to Restore Missing Column Data in Clay Table? | Clay

How to Restore Missing Column Data in Clay Table?

Hi Clay Team- Wondering if there's a way to figure out how to reinsert the missing column data to run this table? https://app.clay.com/workspaces/507736/workbooks/wb_B8AaYTsHgks5/tables/t_EjdvZUpaD3S5/views/gv_R5sxQFBMTDdj

4 comments

Channeled
APP
·
·
To reinsert missing column data in your Clay table, you have a few options: 1. Import CSV: • Go to 'Actions' > 'Import' > 'Import from CSV' • Upload your CSV file with the missing data • Choose 'Add to existing table' and select your table • Map the columns to align with your table structure • Click 'Add to table' 2. Manually add data: • Click '+ New Row' at the bottom of your table • Enter the missing data manually Unfortunately, we can't recover deleted columns. You'll need to recreate them and re-fetch data from providers if necessary. If you need more specific help, consider using our "write to table" feature or request human assistance by clicking on 'Talk to a person'.
Sources: Import a File Upload CSV to your table - Clay University
Owen C.
·
·
Hey Adam, thanks for reaching out! Absolutely, we're going to have to standardize a specific data point in both tables, then use a single row lookup to pull this data from the company table into this people table. Essentially, what I would recommend doing is: 1. In the Indeed V2 table, use a "Normalize a Domain" enrichment and run all of the ChatGPT output domains through this column and format the url to be "bare" 2. Then use a "single row lookup" in this person table to lookup that newly created column containing bare URL's and lookup this record using the domain that is passed over in the "Imported Profiles" column. Let me know if this helps! Happy to dive in further. :)
(471 kB)
Adam G.
·
·
Owen C. my head just spun as I read what to do. Will give it a try!
Owen C.
·
·
Sounds great! Let us know how this goes!! :)