Checking Completion of Waterfalls and Enrichments on a Row

Andrew T. · 2024-09-06 17:30:19.908371+00

Hey team - Is there a way to know when all waterfalls and enrichments have completed on a row? I'd like to use this as a condition to take a final step.

Checking Completion of Waterfalls and Enrichments on a Row | Clay

14 comments

· Sorted by Oldest

Andrew T.
·
·
General question, but here's the table I'm working with https://app.clay.com/workspaces/10648/tables/t_V47tNzMiuS5a/views/gv_CqwDAtZkuSde
Channeled
APP
·
·
👋 Hey there! Our support team has got your message - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!
Andrew T.
·
·
In the example table above, row 3 has completed running, but no phone number was found in the waterfall. Row 4 completed, but no email was found in the waterfall. If I do a conditional field to just look for values in the final output fields of the waterfall, it wont know if the enrichment is still running or if the enrichments completed and no result was found.
Andrew T.
·
·
I've been doing more work in this table, and I also added the "Enrichment Validation" column based on a formula. If this formula waits to run until the enrichments/waterfalls are all complete, this would do the trick. I'd be curious to hear your thoughts.
Tanvi R.
·
·
Hey Andrew, I just checked your enrichment validation column and the logic looks good! I'm not sure if there's a method to filter after the enrichments/waterfalls are complete since some of the final output rows don't have results. Checking with the team and will let you know if there are any solutions here. As a workaround, you can run this column manually if you turn off autoupdate in your table. Let me know if this makes sense and if you have any other questions!
Andrew T.
·
·
Okay, I'd love to hear what the team says on this. Being able to this would be really great and better than manual processing.
Channeled
APP
·
·
Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.
Andrew T.
·
·
Okay, I'd love to hear what the team says on this. Being able to this would be really great and better than manual processing.
Andrew T.
·
·
I've made a few tweaks to make the formula fields dependent on outputs, and I think that this means the formula output will wait for enrichment output to finish and complete. It would be good to get confirmation, but so far, this is working for my testing.
Tanvi R.
·
·
This is great Andrew, really simple yet creative logic you've built here. I just shared this column internally with the rest of the team, will let you know what feedback they have!
Tanvi R.
·
·
Hey Andrew, just wanted to let you that a few people from the team took a look at your formula and are really impressed with the formula you built! We are looking into seeing if this is something that can be made into a template for all Clay users. Keep us posted as you continue to test this on more rows! 🤙
Andrew T.
·
·
Super kind! So far, so good!
Channeled
APP
·
·
Hi Andrew T.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Andrew T.
·
·
FYI Tanvi R. - I did end up tweaking this a bit to check for duplicate contacts already in my system.

Andrew T.
·
·
General question, but here's the table I'm working with https://app.clay.com/workspaces/10648/tables/t_V47tNzMiuS5a/views/gv_CqwDAtZkuSde
Channeled
APP
·
·
👋 Hey there! Our support team has got your message - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!
Andrew T.
·
·
In the example table above, row 3 has completed running, but no phone number was found in the waterfall. Row 4 completed, but no email was found in the waterfall. If I do a conditional field to just look for values in the final output fields of the waterfall, it wont know if the enrichment is still running or if the enrichments completed and no result was found.
Andrew T.
·
·
I've been doing more work in this table, and I also added the "Enrichment Validation" column based on a formula. If this formula waits to run until the enrichments/waterfalls are all complete, this would do the trick. I'd be curious to hear your thoughts.
Tanvi R.
·
·
Hey Andrew, I just checked your enrichment validation column and the logic looks good! I'm not sure if there's a method to filter after the enrichments/waterfalls are complete since some of the final output rows don't have results. Checking with the team and will let you know if there are any solutions here. As a workaround, you can run this column manually if you turn off autoupdate in your table. Let me know if this makes sense and if you have any other questions!
Andrew T.
·
·
Okay, I'd love to hear what the team says on this. Being able to this would be really great and better than manual processing.
Channeled
APP
·
·
Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.
Andrew T.
·
·
Okay, I'd love to hear what the team says on this. Being able to this would be really great and better than manual processing.
Andrew T.
·
·
I've made a few tweaks to make the formula fields dependent on outputs, and I think that this means the formula output will wait for enrichment output to finish and complete. It would be good to get confirmation, but so far, this is working for my testing.
Tanvi R.
·
·
This is great Andrew, really simple yet creative logic you've built here. I just shared this column internally with the rest of the team, will let you know what feedback they have!
Tanvi R.
·
·
Hey Andrew, just wanted to let you that a few people from the team took a look at your formula and are really impressed with the formula you built! We are looking into seeing if this is something that can be made into a template for all Clay users. Keep us posted as you continue to test this on more rows! 🤙
Andrew T.
·
·
Super kind! So far, so good!
Channeled
APP
·
·
Hi Andrew T.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Andrew T.
·
·
FYI Tanvi R. - I did end up tweaking this a bit to check for duplicate contacts already in my system.