Reducing the Number of Rows per Value in a Cell for Company Entries | Clay

Reducing the Number of Rows per Value in a Cell for Company Entries

is there a way for me to reduce the number of rows per value in a cell? Again, basically i have lots of entries for the same company but I don't want to have more than like 3 for each company...?

✅1

12 comments

Mohan
·
·
https://app.clay.com/workspaces/28547/tables/t_Re6ChGEIY18J/views/gv_LRcIhhOxxBP1
Clay Team
APP
·
·
Hey!! Yup, it should be possible. If you don't want to dedupe because you need all contacts but you only want to enrich companies once, I'd recommend keeping 2 separate tables where 1 you have only unique rows of these values and the other table where you'd have several.
Clay Team
APP
·
·
I would then enrich the unique values in the other table and use a Lookup to pull in the data to the other table based on the matching values.
Mohan
·
·
but how would I confine it to a certain number
Mohan
·
·
also to add to the complexity (lol) I would ideally like to preference certain titles to keep vs those to get rid of
Mohan
·
·
do you have a video on how to do this?
Mohan
·
·
ah sorry also, I think I misexplained, I need to do it across an entire column
Mohan
·
·
not within one cell
Clay Team
APP
·
·
Ahh, okay, so guessing this was related to what we covered instead of a different example. Let me know!
Ian M.
·
·
Hi Mohan, I've been building something structurally very similar. Basically a Company Master Table, a People Master Table plus an Add Person and Add Company Table I use the find keywords and have built a scoring model to categorise Companies based on Description, Summary etc And the same for People Based on Job Title, Headline, Summary etc And I use the score, to drive the decision as to if to write the Company or Person to the master tables. If you really want a limit (vs simply taking just the ones you want) then you could do a look-up from the Add tables to see how many you have in the Master Table to see if you have filled your "quota" or not. Hope this helps ian
Ian M.
·
·
(one thing to point out to be carefull - if you are matching on URLs, then you need to normalise and make sure you strip off any "fluff" (eg UTM tags) that might have been passed in
🔥1
Mohan
·
·
hey Ian, yeha that's what I did in the end too - scored them, and then i could reduce the number of those i valued less...but would be great to have a native clay function for it
:thumbsup_all:1