Clay Icon

Troubleshooting Column Update Error and Infinite Loop in Data Table

ยท
ยท

Hi! I'm getting this error when I try to update the column where the data is coming from. Wonder what it could be or how could I fix it? I checked the rest of the table and I'm not sure where the infinite loop could be.

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    To fix the error when updating the column, try these steps: 1. Delete the affected column. 2. Create a fresh column. 3. Re-map your data to the write to table function (ensure auto-dedup is activated in the other table). If this doesn't work, you can try using the Force Run option: 1. Right-click on the column. 2. Hover over "Run Column" > "Force Run All Rows". To identify an infinite loop, check your write to table configurations. Ensure you're not writing to a deleted column or sending data to a table that references another table, which can cause conflicts. If issues persist, consider reconfiguring your write to table integrations and double-check that all columns and tables exist and are correctly set up.

  • Avatar of Michelle M.
    Michelle M.
    ยท
    ยท

    No, how to stop the infinite loop?

  • Avatar of LuisArturo
    LuisArturo
    ยท
    ยท

    Hey there Michelle thanks for reaching out, question what are the inputs that you were using to run this integration? Also a good way to check where a loop may be occurring is by using the Graph view of the table which can be accessed by clicking on the arrow next to the table name in the workbook tab.

    (25 kB)
    Image
  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท