Extracting LinkedIn Titles and Companies into a Single Column | Clay

Extracting LinkedIn Titles and Companies into a Single Column

I have a series of work experience that comes from LinkedIn data (see attached). Is there a way to extract the title and company name for each and put that into a single column? Basically instead of creating a column for each - I'd like to have a single column that lists all.

14 comments

Channeled
APP
·
·
You can use a table lookup to combine the title and company information into a single column. Here's how: 1. First, click on any row in the Company column to pull a lookup of all fields from the company table. 2. Once you have access to both the company and contact data, you can map out the specific fields you want to combine (title and company name). 3. Create a formula column that combines these fields in your desired format (e.g., "Title at Company Name").If you need more specific guidance on setting up the formula or mapping fields, please let me know.
Channeled
APP
·
·
Is that what you were looking for?
kushagra
·
·
yup you can do that using a formula
Channeled
APP
·
·
That's great! I'm happy to answer more questions if you have them.
Channeled
APP
·
·
Hi William F.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
kushagra
·
·
William F. here you go - use this in a formula column and it will give you title and company name JSON.stringify({{Enrich Person from Profile}}?.experience?.map(exp => ({title: exp?.title, company_name: exp?.company})))
Channeled
APP
·
·
Thank you for sharing that helpful formula! I'm glad I could assist you with your query.
William F.
·
·
Thanks so much!
William F.
·
·
This is great you are really helpful.
Channeled
APP
·
·
Thank you so much for sharing your feedback William F.!
kushagra
·
·
glad to help 🙂
Channeled
APP
·
·
I'm delighted to hear that! I'm always here if you need any further assistance.
Nate F.
·
·
you can also do the filter list objects enrichment
➕1
Channeled
APP
·
·
Can you tell me more about the filter list objects enrichment you mentioned? What specific aspects of it are you interested in or would like to know more about?