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?
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! 💪✨