.png){kind=logo}
Troubleshooting Data Transfer Issues Between Tables in SQL
I am using write to Other table to pass data from one table to another but it is only passing data from one column while I am passing around 10 columns. what might be the reason behind this
There could be a few reasons why our "write to table" feature isn't passing all 10 columns as expected: 1. Column mapping: Ensure you've correctly mapped all 10 columns from the source table to the destination table. 2. Configuration issue: Double-check that all columns and tables exist and are correctly set up. 3. Processing error: Try using the Force Run option in the table settings. This may take some time depending on your table size. If the issue persists, you could try: 1. Deleting the affected columns 2. Creating fresh columns 3. Re-mapping your data (ensure auto-dedup is activated in the other table) If you need further assistance, please request human support by clicking on "Talk to a person".
Hi Aditya, could you share the url to the table you're writing these records from? Would be super helpful!
Bruno R. Here is the table from where I am passing my data to other table: Clay | Website Visitor - B2B Here is receiving table: Clay | Visitors IT Services Clay | Visitors Others
Hey there, thanks for your message I just recorded this quick video to explain: https://www.loom.com/share/7efda9b3719f4ac3993d1ab303d87cb6?sid=e617c933-fd5e-4eb3-8e40-c2bfacd80a02 Let me know if this makes sense - the issue looks to be associated to the varying payload from row to row, which you're receiving in your webhook endpoint.