.png){kind=logo}
Joining and Collecting Email Data from One Table to Another
how do I join and collect all the email information from an existing table and bring it into a new table?
how do I join and collect all the email information from an existing table and bring it into a new table?
To join and collect email information from an existing table into a new table, you can follow these steps: 1. Open the existing table with the email information. 2. Click on "Actions" > "Import" > "Import Companies From a CSV". 3. Select "Create New Table" > "Import". 4. In the new table, you can now import the data from your existing table. 5. Choose the columns you want to include, focusing on the email information. 6. Click "Add to table" to complete the process. Alternatively, you can download your existing table as a CSV and then import it into a new table using the same process. This method allows you to select specific columns and create a new table with just the email information you need. If you need further assistance, please ask to talk to a person in this chat.
Source: Import a File
no
i have this table of contacts: https://app.clay.com/workspaces/180544/workbooks/wb_BF8NRbHQQBWS/tables/t_W48PqyyUsdEK/views/gv_vFaMnMtF4DYg I'd like to add the email columns from this table: https://app.clay.com/workspaces/180544/workbooks/wb_BF8NRbHQQBWS/tables/t_z2vMg92KmrsN/views/gv_SN8ENawBMmUE how do i do this?
We have two ways of doing this: [ 1. **Write to Table::**](https:://www.clay.com/university/lesson/write-to-table-clay-101) You can send data into a new table using the “write to table” option. This is great for sending lists of objects, individual values, or both. For example, if you have an enrichment with a list of multiple objects, you would select the “write to table list” option. You can also add other values to match that are in this table but not as a list. [ 2. **Lookup::**](https:://www.loom.com/share/ad767e3be9914d19a2f6647efe4dfa85?sid=c8b78c32-9bc1-4501-8124-d6c70d2218cf) If you want to add more information that you already found from a previous table to the current data you have (e.g., matching domains), then “lookup” is the best option. This allows you to call matching data into one table. Let me know if that answers your questions. Happy prospecting! 💪✨