Can I update another table with information I enriched from another table, but for example I just want to send company domain for some reason I am getting errors. I know update table tool works well for all the columns, but what am I supposed to do when I just want to send couple columns?
Yes, you can send specific columns using write to table. In Step 4: Map out columns, select only the columns you want to copy from the source table and match them to the appropriate columns in the destination table. For column mapping, enter "/" in the list selection step to skip it, then choose which specific columns (like company domain) to transfer between tables. If you're getting errors, check that: - Your destination columns exist and aren't deleted - You're not writing to a table that references another table - Your API key is correctly configured
Exactly! When using write to table, you can select only specific columns in Step 4: Map out columns. Choose just the columns you want to transfer (like company domain) and match them to the destination table columns. In Step 3, enter "/" to skip list selection, then map only your desired columns rather than all available ones. This prevents errors and sends only the data you need.
I am receiving an error saying it would create a cycle
The "cycle" error occurs when there's a circular dependency in your write to table setup. This happens when you're sending data to a table that references another table, creating an infinite loop. To fix this: ** Check that you're not writing to a table that references your source table ** Ensure all destination columns exist and aren't deleted * Reconfigure your write to table integration to break the circular reference You can also disable "auto-update" for columns to avoid unexpected updates based on other columns' dependencies.
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in Clay Support.
