Merging Additional Columns from Table 2 into Table 1 Efficiently | Clay

Merging Additional Columns from Table 2 into Table 1 Efficiently

Hello, I have 2 tables In one table, I have used some credits to add data to one column In the other table (it is the same extract of the first table, but with additional columns) The only difference is that in Table 1 there are 770 rows, and in table 2 there are 771 rows. How can I push the 2 additional columns from Table 2 into Table 1 (where I have used credits) while keeping in mind the difference of one row?

8 comments

Channeled
APP
·
·
To push the two additional columns from Table 2 into Table 1, you can use our "write to table" feature. Here's how: 1. Open the table containing the additional columns (Table 2). 2. Click on "Actions" and select "Write to Other Table". 3. Choose Table 1 as your destination table. 4. Enter "/" to skip list selection. 5. Map the two additional columns from Table 2 to new columns in Table 1. 6. Configure run settings if needed (e.g., auto-update for new rows). Keep in mind that this process will align data based on matching rows. Since there's a difference of one row between the tables, you may need to review and adjust the data after the transfer to ensure accuracy. If you encounter any issues, you can try deleting the affected columns in Table 1, creating fresh columns, and re-mapping the data.
Sources: Write to Other Table | Documentation | Clay University Write to Other Table | Documentation | Clay University Table columns | Documentation | Clay University
Abhishek
·
·
The new columns were created in Table 1, but there is no data in the columns
Abhishek
·
·
https://app.clay.com/workspaces/367095/workbooks/wb_dp5YVBUGSzUN/tables/t_a6tGrKCFBWdQ/views/gv_8kjKecYeJzsf
Abhishek
·
·
help please
Daniela D.
·
·
Hey Abhishek! Thanks for reaching out. Happy to help✨. You can do this with the lookup row integration. I made a quick video showing how to configure this: https://www.loom.com/share/730eb11452b642a1bd95fe17d0ed8fa7 Let me know if that helps!
Abhishek
·
·
Thanks a ton, Daniela, really appreciate it!
Channeled
APP
·
·
Channeled
APP
·
·
Thank you so much for sharing your feedback Abhishek!