.png){kind=logo}
Creating a Blank Column for Data Mapping in SQL
Attempting to write to table 1 column from a table to another table. How do I create a blank column with a column name destination in the receiving table so it can be mapped from the original table?
Attempting to write to table 1 column from a table to another table. How do I create a blank column with a column name destination in the receiving table so it can be mapped from the original table?
To create a blank column in your destination table for mapping:
1. Add a new column: Scroll to the right of your destination table and select Add column, or use the dropdown menu on an existing column and choose Insert right or Insert left.
2. Set the data type: In the column creation dropdown, specify the data type for your new column (e.g., Text, Number, Date).
3. Name your column: Give it the desired column name that matches what you want to map from your source table.
4. Use write to table: When setting up your write to table feature, you can then map columns from your source table to this newly created destination column.
Show me how to set up write to table.
Here's how to set up write to table: Step 1: Select your Clay account If no account is selected, obtain your API key to set up a Clay integration. Step 2: Select a table to write to Choose a destination table, ideally within your current workbook. Step 3: Choose your mapping type ** For list mapping: Select the column containing lists you want to map to rows ** For column mapping: Enter "/" to skip list selection Step 4: Map your data Select the columns you want to copy from the source table and match them to the appropriate columns in the destination table. Step 5 (Optional): Configure run settings ** Auto-update will automatically enrich new rows if added ** Only run if allows you to set conditions controlling when the action runs
See screenshot or url https://app.clay.com/workspaces/507736/workbooks/wb_0t126o3paTFnGKEMHVo/tables/t_0t126o3Vr2vcxWrkfMD/views/gv_0t126o3qgVBDby7TBRX i thought I had this mapped and set up right but I'm not getting the data from source table to other table. Looks like it's mapped correctly. What am i doing wrong?
Yes, we have two ways of doing this. Sounds like you're trying to append the data to a column that already exists, so in your case, it'd be 2. If you're trying to create a net new row, it'd be the write to other table/send table data, yes. 1. [Send Table Data::](https:://www.clay.com/university/guide/send-table-data) You can send data into a new table using the “Send Table Data” 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! 💪✨
Hey Adam, Just to confirm — you’re not trying to send data into a column of a row that already exists, right? ** If you want to append data to an existing row, you’ll need to use Lookup. ** If you want to send data into a column of a new row, you can use Write to Other Table, which maps columns across tables but creates new rows — it won’t backfill existing ones. ** If you just want to push data over without maintaining a live connection, *Send Table Data works for that. Let me know which setup you’re aiming for and I can walk you through it.
i'd like to simply send a single column (1 row) from 1 table to another. In this case, it is static data. Nothing needs updating. I have a list of verified emails from 1 data source (zoominfo) and i want to push it in to another table with clay data provider sourced verified emails. I'll merge the 2 columns and dedupe the rows to see the total net new verified emails.
I recorded this walkthrough video showing exactly how to set this up: https://cln.sh/XTWpjbcx Let me know if you have any follow-up questions!
Bo (. Whew! Done. It was the filters and the way it populates below the last line on the destination table that confused me. Thanks really appreciate your help. I'll see how the deliverability goes with this campaign. It's interesting that clay data provides found about 156 verified emails and zoominfo came up with 126 verified emails and only 56 emails were duplicates. I have a feeling I may see poor deliverability on this campaign but it's a small sample size. Shouldn't be too damaging if too much if there are some bounces. Thanks again for your help.
Hey, glad to hear you got it sorted. Good luck with the campaign — hope deliverability goes smoothly. Let me know if you need anything else.