Prevent Duplicate Waterfall Runs on Repeated Items to Save Credits

·

Hi, is there a formula that will make a waterfall only run one time if an item is repeated? Example, I have a list of leads and some share a Company, and I need to find the domains but I don't want to waste 2 credits if I can spend just 1 for the company. Does anybody know?

2 comments

· Sorted by Oldest

Jani Vrancsik
·
·
you can remove duplications with the dedupe function before you run the waterfall
Amit Sarda (Clay Expert)
·
·
Create a separate table with the name/url/linkedin of the company. Dedupe the list, and then enrich the company info. Then use a Clay lookup in the original table to fetch the info.

Jani Vrancsik
·
·
you can remove duplications with the dedupe function before you run the waterfall
Amit Sarda (Clay Expert)
·
·
Create a separate table with the name/url/linkedin of the company. Dedupe the list, and then enrich the company info. Then use a Clay lookup in the original table to fetch the info.