.png){kind=logo}
How to Merge Multiple Tables into One in Excel Workbook
i have a workbook with a few tables. Can i bundle/merge/combine them into one table?
i have a workbook with a few tables. Can i bundle/merge/combine them into one table?
Yes, you can combine data from multiple tables using the Write to Table integration. Here's how: 1. Click "Add Enrichment" in the top right corner of your page 2. Search for and select "Write to Table" integration 3. Choose your destination table (where you want the combined data) 4. Map the columns from your source table to the corresponding columns in your destination tableYou can repeat this process for each table you want to combine, writing the data into your chosen destination table. The Write to Table integration allows you to transfer and consolidate data across different tables effectively. Source: Write to table integration overview | Documentation | Clay University
does this cost credit?
No, using the Write to Table integration does not cost any credits. It's one of the free actions you can perform in Clay. List building, data cleaning, and transferring data between tables are all free operations. Credits are only charged for data enrichment operations, such as when you need to get new data from external providers for things like fundraising data, LinkedIn profiles, contact information, or AI web scraping. Sources: Clay credits overview | Documentation | Clay University Which actions cost credits (or are free)? - FAQ | Clay.com
when i write to table, I cannot import the imported profiles and company table data
Based on the error you're experiencing, this issue typically occurs when there's invalid or conflicting data in your setup. This can happen when: 1. You're trying to write to a deleted column 2. You're attempting to send data to a table that references another tableTo resolve this, try these steps: 1. Reconfigure your Write to Table integrations from scratch 2. Verify that all columns exist in both source and destination tables 3. Double-check that your column mappings are correct 4. Set up the integrations again to ensure there are no misconfigurationsIf you continue to experience issues, you may want to request human support for more specific troubleshooting. Source: Write to table integration overview | Documentation | Clay University