Moving experiences collection into a column in the CONTACTS TABLE for filtering and lookup

question: in a COMPANIES TABLE , I do Find Contacts at Company Enrichment, then I move those records into another table. This enrichment can bring from 1 to N Contacts. Now, apart from copying name, title and so, in each of those records, under experiences collection from linkedin, I would like to be able to identify if there is any experience item Is Current = True, and then get the start date for those So probably I can move the entire experiences collection into a column in the CONTACTS TABLE ? and then apply some clay filtering/lookup?

✅1

6 comments

Esteban L.
·
·
it would be something like select a list from a column, people, and then within a field in the destionation table, copy also a list from a column under people item > experiences
Esteban L.
·
·
like copying people records into destination table for each company record, and then in a field on destination table, within each of those records, copy the experience collection, Is it that possible? Is there any workaround I'm missing? thanks
Gleb K.
·
·
I think that's a good way to do it, just apply the proper filtering when finding the people within those companies. Then use a conditional formula to run only if the experience matches your requirements. Not sure if I'm missing anything
Clay Team
APP
·
·
You can likely use "Write to other table" for this Esteban L.!
Clay Team
APP
·
·
https://docs.clay.com/enrichments-and-providers/enrichments/all-providers/clay/write-to-other-table
Clay Team
APP
·
·
Curious though why you're using "Find Contacts at company" instead of the "Find People" workflow?

Moving experiences collection into a column in the CONTACTS TABLE for filtering and lookup | Clay