Mapping Subject Lines from Table A to Contacts in Table B

Hello peeps. Table A consists of companies. Table B, contacts at those companies. As you would expect, table B consists of more rows that table A as each company has multiple contacts. I decided to write the subject line at a company level, so the formula is in Table A. I want to map that subject line to contacts in Table B, as the rest of the email copy will be an individual level. Write to table, the column header was created, the subject line was not populated. Is what I am trying to do possible?

11 comments

Channeled
APP
·
·
You can map the subject line from your company table (Table A) to your contacts table (Table B) using the Write to Table integration. Here's how: 1. Add a Write to Table enrichment to Table B 2. Select Table A as your source table 3. Enter "/" to skip list selection since you're doing column mapping 4. Map the subject line column from Table A to the corresponding column in Table BIf the subject line is not populating, you'll need to ensure that: ** The company data is properly linked between both tables ** You've rerun the lookup to refresh the data connection between tablesThe Write to Table integration will help you establish this connection and transfer data between your tables, making it ideal for scenarios where you need to map company-level data to individual contacts. Sources: Write to table integration overview | Documentation | Clay University Enrich People (Waterfalls) [CRM Enrichment] - Clay University
kushagra t.
·
·
In Table B add a lookup multiple rows enrichment. Use the company domain in table B to lookup the company details from table A. Then you can use the company details (ie sub line) from table A in table B.
Channeled
APP
·
·
You can map the subject line from Table A to Table B by using the "Lookup Single Row in Other Table" enrichment. Here's how: 1. In Table B, add a "Lookup Single Row in Other Table" enrichment 2. Select the company domain column from Table B as your matching field 3. Choose Table A as your reference table and select the corresponding domain field to match against 4. Select the subject line field from Table A that you want to bring into Table BThis will create a connection between your tables, allowing you to pull the subject line data from Table A into Table B for each matching company domain. Sources: Write to Table [Clay 101] - Clay University Find People [Clay 101] - Clay University
Charles T.
·
·
Thank you kushagra t. - that makes sense. Will try now.
1
Charles T.
·
·
It's kind of a reverse lookup i.e. child to parent.
Channeled
APP
·
·
Great! I'm here if you need any further assistance.
Channeled
APP
·
·
To perform a reverse lookup from child to parent table (like mapping company data from Table A to contacts in Table B), you can use the "Lookup Multiple Rows in Other Table" or "Lookup Single Row in Other Table" enrichment. Here's how: 1. In your child table (Table B - contacts), add a "Lookup Single Row in Other Table" enrichment 2. Select the parent table (Table A - companies) as your "Table to Search" 3. Choose your matching field (like company domain) that exists in both tables 4. Select the fields you want to pull from the parent table (like the subject line)The "Lookup Single Row" option is recommended for better performance when you expect one-to-one matches. Use "Lookup Multiple Rows" only if you need to retrieve multiple matching records from the parent table. Sources: Lookup Multiple Rows in Other Table with Clay Lookup Single Row in Other Table with Clay
kushagra t.
·
·
Yup, as long as you have a common unique identifier (domain, linkedin url, etc) at a row level in both tables, you can use the lookup enrichment to get data from one table to another.
Channeled
APP
·
·
That's great! I'm happy to answer more questions if you have them.
Channeled
APP
·
·
Hi Charles T.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Channeled
APP
·
·
I'm glad I could help! I'm here if you have any more questions.

Mapping Subject Lines from Table A to Contacts in Table B | Clay