Remove Duplicate Jobs Imported from LinkedIn

Hi team, I have imported jobs from LinkedIn into a table and there are a lot of duplicates, please help me remove them: https://app.clay.com/workspaces/217803/tables/t_OoEzBe3ZMNng/views/gv_qVyvhVMRVLtc

· Sorted by Oldest

Clay Team
APP
·
·
Hey Reyhan, Sorry for the delay! Just to confirm, you want to de-duplicate rows that have the same job LinkedIn url?
Reyhan K.
·
·
Yes, or can we dedupe for other variables such as company domain?
Clay Team
APP
·
·
Yeah, that works too. Your table is deduped✅ For future, you can select any column with the data point you want to dedupe and select the dedupe option in the drop down menu (see screenshot). Let me know if this helps!
c47da683-1efa-44d7-83c8-e2dcaf0f770e.png(23 kB)
Reyhan K.
·
·
Legend

Clay Team
APP
·
·
Hey Reyhan, Sorry for the delay! Just to confirm, you want to de-duplicate rows that have the same job LinkedIn url?
Reyhan K.
·
·
Yes, or can we dedupe for other variables such as company domain?
Clay Team
APP
·
·
Yeah, that works too. Your table is deduped✅ For future, you can select any column with the data point you want to dedupe and select the dedupe option in the drop down menu (see screenshot). Let me know if this helps!
c47da683-1efa-44d7-83c8-e2dcaf0f770e.png(23 kB)
Reyhan K.
·
·
Legend