Clay Icon
Join the Community
02 Support

Prevent Duplicate Waterfall Runs on Repeated Items to Save Credits

Avatar of Pilar V.Pilar V.
·
·

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

  • Avatar of Jani V.
    Jani V.
    ·
    ·

    you can remove duplications with the dedupe function before you run the waterfall

  • Avatar of Amit S.
    Amit S.
    ·
    ·

    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.