is it possible to create a table in clay starting from an apollo list, or a crunchbase saved search? if not, which will be for you the workaround considering the csv export limitations?
I'd recommend turning the table off, clicking on the column header that may have duplicate values, and then using the dedupe feature to get rid of them. That would help save on credits.There's also a more automated way for this, by using the Lookup record integration to search if the value already exists in the same or a different table and you can then use conditional formulas to prevent other columns from running; this doesn't remove duplicates though... Here's a video and our docs page for Lookup Record!
.png){kind=logo}
