Hello here.

·

Hello here. I need a formula in my company name column where i need to remove all duplication of company name and leave only one. As the context is that i have many rows in my clay table where one company is recruiting many position in there company.

3 comments

· Sorted by Oldest

Clay Team
APP
·
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
rumjan y.
·
·
https://app.clay.com/workspaces/145434/tables/t_FZ8k6aMDtEZF/views/gv_iIdU8gXhrKF2
Clay Team
APP
·
·
Just replied to your other thread but in case you see this first: You can actually use our "dedupe" feature. If you click on the column header with duplicate values, it should be visible in the menu. Let me know if you run into any issues!
3f8dcda5-8fcb-41c0-9fe9-987fca8d69d4.png(25 kB)

Clay Team
APP
·
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
rumjan y.
·
·
https://app.clay.com/workspaces/145434/tables/t_FZ8k6aMDtEZF/views/gv_iIdU8gXhrKF2
Clay Team
APP
·
·
Just replied to your other thread but in case you see this first: You can actually use our "dedupe" feature. If you click on the column header with duplicate values, it should be visible in the menu. Let me know if you run into any issues!
3f8dcda5-8fcb-41c0-9fe9-987fca8d69d4.png(25 kB)