I'm having issues using the Array Position formula provided by the Clay team - more details in this Loom: https://www.loom.com/share/6c8b7bf9edd24efabfcdeea8b0d93898 here's the video guide I received for numbering rows: https://www.loom.com/share/42c7f8be9bbd4ca69165e01d6377dd01?sid=f0234a49-0e17-4ae6-ac96-799aa40d53eb Link to Clay table: https://app.clay.com/workspaces/354814/workbooks/wb_yminVz8MSaiB/tables/t_Ytki9s879ZBb/views/gv_vKGRmkqyXGgi
Hello - I'm trying to create an enrichment that will handle deduplication according to the following algorithm:
check if the URL in first column is unique to list
if the URL is unique, copy the value of first column & second column into the output columns
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
Hi team - I'd love your help with something. I've created a workbook with multiple tables in it, each table contains some company URLs. Right now, I'm looking do the following:
Automatically add all the URLs from each of the tables into a new Consolidated URL table
Run a dedupe on the Consolidated URL table so I am left with only a list of unique URLs
Configure this to run automatically (i.e., if i ever add new URLs to any table, the URLs will be sent to the Consolidated URL table and a dedupe is run
Here's a video with more detail: https://www.loom.com/share/06e695a3c33149f4887a813beee12f66
