Home

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Explore Events
Learn Clay here
Clay Cup

Powered by Tightknit

How to Merge Columns from One Table to Another in Data Scraping | Clay

How to Merge Columns from One Table to Another in Data Scraping

·Aug 26, 2025 08:22 PM·

Hey everyone, I woule like to add two columns from a table to an another one. For example I scrape Jobs from Linkedin, when I look for people, I lost the name of the job. Do you know to keep this info in the new table? Thanks!

12 comments

· Sorted by Oldest

Preeti M.
·
·
lookup against the previous table
Preeti M.
·
·
use lookup single row using the company domain or company LI (whatever is the common field in both tables) or multiple if you have multiple jobs open for one company
Julien B.
·
·
Preeti M. Thanks!!
1
Julien B.
·
·
Preeti M. It says he found the record but I don't know how to copy the info in the second table
Julien B.
·
·
Loading attachments
Preeti M.
·
·
Do the lookup in the other table where you want this info
Julien B.
·
·
Now yes, but I have an error. Here what I have: https://www.loom.com/share/b0b12a0815b1497f9a5976e5f56e921a?from_recorder=1&focus_title=1
Preeti M.
·
·
Hey Julien B. the target column is a value such as company domain or company LinkedIn which exists in both tables and then the row value is the same company domain or company LinkedIn in your current table
Preeti M.
·
·
And then you’ll be able to extract the job title. Since you have multiple jobs for the same company I would suggest using lookup multiple rows instead of lookup single row integration
Julien B.
·
·
Thank you Preeti M. I did this :
Loading attachments
Julien B.
·
·
But 0 record found for the first 10 lines
LuisArturo
·
·
Hey there Julien so sorry for this delay. We had an issue with our support tooling that caused this message to be missed, but we're making changes to ensure this doesn't happen again. Do you mind sending the link (url) to the table so we can take a look?
Loading attachments