How to Link Company News to People Table in Your Database? | Clay

How to Link Company News to People Table in Your Database?

This might be a very silly question, but when I do a lookup from a different company table to the people table. I wanted the company news. This data has multiple outputs in the company table. When I create a new column it doesnt show any news. Its not clickable. Would anybody know how to do this? Posted this by mistake in this channel. Cannot delete it.

12 comments

Muhammad S.
·
·
You need to click on this cell and then map the column you want to map i.e company news
Sahil S.
·
·
Yes after mapping I got the column on the right in the image
Muhammad S.
·
·
can you click on the cell as shown in the screenshot and share a screenshot
Sahil S.
·
·
When I click a cell from the left column I get the expand option for records. I have used the same to create the column on the right. When I click the cell in the right column, I dont get anything.
Muhammad S.
·
·
click here and it will show you all the columns from the other table
Sahil S.
·
·
yes thats what I have done to get the column named recent company news
Muhammad S.
·
·
can you click on that arrow and share screenshot?
Sahil S.
·
·
Muhammad S.
·
·
this is the available data that you can map, the column that you are trying to map is not present in this data?
Sahil S.
·
·
It is present "Find most recent news"
kushagra t.
·
·
You need to add the news found in the company table into a column in the company table. Since there are multiple (18) entries use a formula to get all the 18 news into one column in the company table. Then do the lookup in people table and you ll get one column with all the news that you can add to the people table. Then again use formulas/AI to parse through it and use.
Sahil S.
·
·
kushagra t. , thanks will try it out and post it here. I did something similar but expanded to 18 different columns without a formula 😅 . Will combine them into one. Thanks
1