Clay Icon

Creating an Enrichment for URL Deduplication and Data Aggregation

ยท
ยท

Hello - I'm trying to create an enrichment that will handle deduplication according to the following algorithm:

  1. 1.

    check if the URL in first column is unique to list

  2. 2.

    if the URL is unique, copy the value of first column & second column into the output columns

  3. 3.

    if the URL is not unique, copy the value of the first instance of the URL into the first output column, then generate a comma-separated concatenated list of unique results from the second column and add it to the second output column

Full details in this Loom: https://www.loom.com/share/3fa72f1ac6e045dcb35d6a5bf1204333 URL to workbook here: https://app.clay.com/workspaces/354814/workbooks/wb_CTtvASKuVkhq/tables/t_8kAasXjbiMko/views/gv_yJcz5ycsPhzZ

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    ๐Ÿ’ค You've caught us outside of our support hours (9am-9pm EST), but don't worry - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in the thread below so that we can help you as quickly as possible!

  • Avatar of Daniel K.
    Daniel K.
    ยท
    ยท

    Hello Remen! Happy to help! I have successfully adjusted the columns to achieve the output you were looking for. For an overview, please refer to this walkthrough: https://www.loom.com/share/9bae7d490c8a4a118af3d8b48c5d7575 Please don't hesitate to reach out if you require any further assistance! :)

  • Avatar of Channeled
    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.

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.