Empty Columns in Company Look Up: Troubleshooting and Fixing the Issue

Hello there. We need some help as to why the columns are not being filled in when we do a company look up they are not returning any information in the cells as the previously have

✅1

19 comments

GEM R.
·
·
https://app.clay.com/workspaces/161420/tables/t_DUiHlvWWQdFQ/views/gv_uS2ki11daACD
Clay Team
APP
·
·
Hi, thanks for getting in touch! I can see that your table is almost empty, including the website column which is mapped in the lookup to match with the google sheet
GEM R.
·
·
We did a company look up from LinkedIn, and saved it to the table template with all of the columns pre formatted. And that's all it produced? It's not running any of the cells?
Clay Team
APP
·
·
Hey GEM R., happy to jump in here as this scenario is not quite common and hard to catch at first glance. What might've happened here is since this was duplicated but the original table had other fields or the field's names were slightly different then that's why it's not detecting where to extract the data from.
Clay Team
APP
·
·
If those values are updated for those columns that should extract the values, then that would allow the rest to be filled automatically. Let me know if you have additional questions or if you need help doing this!
GEM R.
·
·
Thank you, but that did not seem to work? I have tried uploading new companies to a new table, and that did not work either?
Clay Team
APP
·
·
Hmm, let me make sure the columns are pulling from the right sources.
Clay Team
APP
·
·
This was the issue, those other columns were referencing a column that didn't exist or didn't have any values. I changed them to pull data from the new import column you added and that fixed it. Let me know if you run into any issues!
GEM R.
·
·
Thank you, but the reason I am importing to the "Latest Company Table" is because I had already formatted the cells with a formula?
Clay Team
APP
·
·
I see, but the issue is that once the import was completed for some reason it didn't link to where it should've sourced the leads from, so it had to be re-mapped, the formulas should still work as long as the data exists. Let me know if you see a column that should be populated because the values it depends on already exist but it doesn't run!
GEM R.
·
·
Right! So I tried uploading new companies to the table, and the columns are not working properly? Same as when I try and upload to a new table, the formulas and columns are not working properly? Is CLAY having any issues on that end? Thank you!
Clay Team
APP
·
·
Thanks for the follow up! Will take a look, but I don't think it's an issue with the system itself but maybe just that template that's not detecting the values once you upload them. As mentioned, if the original source was a different column and that's where it was pulling data from then the format has to match for any new data sets that get added so they're auto-detected.
Clay Team
APP
·
·
I see the formula columns but they're only returning specific words, is that the expected behavior, or was it supposed to return different values depending on criteria?
Clay Team
APP
·
·
Also, I think this may be part of the issue (maybe?), the table is turned off so it doesn't auto-update.
GEM R.
·
·
Here is the issue... Is there anything you can suggest or do? I can't seem to upload any new companies to ANY tables. And I have tried everything you have suggested? Thanks again! Look forward to hearing from you.
GEM R.
·
·
https://app.clay.com/workspaces/161420/tables/t_cFWOw2zQAz3d/views/gv_QfWPSHprmr09
GEM R.
·
·
That is a table that was working, when importing to the the copied table? How come now its not working to do the same thing?
Clay Team
APP
·
·
Got it! I sent you a video directly, hoping to cover what I saw and explain what's going on. Let me know if that covers some of these questions and if there are others to go over!
GEM R.
·
·
Thank you very much!!

Empty Columns in Company Look Up: Troubleshooting and Fixing the Issue | Clay