How to Make a New Column Visible and Populated in a Child Table | Clay

How to Make a New Column Visible and Populated in a Child Table | Clay

Steve C.
·
·
https://app.clay.com/workspaces/161589/tables/t_eWbtCXvXx8nz/views/gv_qNd0bTk1nkE0
Steve C.
·
·
I want to add "Industry" in the parent table to this child table.
Clay Team
APP
·
·
Hey Steve, thanks for reaching out! That "Company table data" column in the contacts table, you can re-run it to update and fetch any changes from the source, like the industry in this case. Then you can extract the values from it to your new table.Let me know if you run into any issues!
c5750ba9-0387-4910-b42b-308f0f8efea1.png(66 kB)
Clay Team
APP
·
·
If it doesn't run with the play button, you can click on the column header ->
c8c68649-a570-45a3-a030-d353a1349921.png(27 kB)
Clay Team
APP
·
·
It doesn't cost any credits so you should be fine!
Steve C.
·
·
Thank you it work.
Steve C.
·
·
However the page does not populate the value right away. It showed the new column, but did not show values. I need to refresh the screen
Clay Team
APP
·
·
Ah, yes, there may have been some latency at the time. If it doesn't populate the values right away or at all after refreshing, let us know to check it out!
Steve C.
·
·
I encountered an issue with the 'Find work email' feature. I used this on the table at https://app.clay.com/workspaces/161589/tables/t_eWbtCXvXx8nz/views/gv_qNd0bTk1nkE0. Despite the initial step successfully finding the email, the subsequent enrichment process continued unnecessarily, consuming a significant amount of my credits. I want to request a refund for these credits. Additionally, I noticed that even though the
Loading attachments
Clay Team
APP
·
·
Hey Steve, sure happy to refund those in this case. We're trying to make that a lot clearer as to what's going on but the short version is that we unfortunately have no control over what data each provider returns and if the emails aren't valid, the next provider is trying to find a new/different one (if it exists or if they have it).
Clay Team
APP
·
·
Here's the extended version and a video with an example if it helps clarify: The waterfall gives you the option to add a validation provider to check results from each email finder. When the validation tool determines the email is invalid, the next email finder tries to find a new one, but if it finds the same email as the previous column it won't try to validate it again because it already tried to validate once before, and this could result in no final output because none were valid.We automatically hide validation columns helping keep tables clean and that's why it's not evident at first glance. Let me know if you still have any questions though!Example and explanation: https://www.loom.com/share/e79acd92841a4706b1710c4ce1bddaa4
Clay Team
APP
·
·
Let me know how many credits it used up in this example and happy to send those back into your account :)
Steve C.
·
·
I have come to understand that Clay should have clearly indicated the potential issues with the waterfall approach. I was under the impression that validation only occurred once, and as a result, I believe I have wasted approximately 2500 credits. I have decided that in general, I will not use the waterfall approach anymore, as it is too dangerous. I am hopeful that Clay can provide something better.
Clay Team
APP
·
·
Appreciate the feedback, Steve! Totally understandable. Of course, to clarify, we don't control the data of any of these providers, we just allow access to their service to aggregate it within Clay. The waterfall serves as the tool to maximize coverage at scale but cases like the above do come up at times.
Clay Team
APP
·
·
What we'll try to do but we would need the cooperation of the providers for that, is asking them to allow us to exclude any records that weren't valid from a previous search so they only return new and unique values themselves if available.Unfortunately, they don't currently offer this option, so it's a bit difficult to find a proper workaround that doesn't involve checking with multiple providers unless you skip the validation step.