Clay Icon
Join the Community
02 Support

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

Avatar of Esteban L.Esteban L.
·
·

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?

6 comments

  • Avatar of Esteban L.
    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

  • Avatar of Esteban L.
    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

  • Avatar of Gleb K.
    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

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    You can likely use "Write to other table" for this Esteban L.!

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Curious though why you're using "Find Contacts at company" instead of the "Find People" workflow?