Clay Icon

Enforcing Column Order in Multiple Write to Tables for Data Enrichment

ยท
ยท

Hey, is there any way to enforce an order in which columns run? With a horizontal setup, using multiple write to tables, I'd like it to only run after all the enrichments have to make sure I'm passing all information to another table. How can I do it?

  • Avatar of Leon W.
    Leon W.
    ยท
    ยท

    bumping this one

  • Avatar of Leon W.
    Leon W.
    ยท
    ยท

    yeah I did it but when I wasn't referencing all these columns in between the write to table would still run and start triggering workflows in other columns. The way I set up my tables is I only pass a Record ID between tables and then do lookups (this way I'm not clogging up columns in the new table) I'd like to automate the last table running only after all previous ones have run regardless whether I'm referencing all columns in the final write to table or now

  • Avatar of Leon W.
    Leon W.
    ยท
    ยท

    not*

  • Avatar of LuisArturo
    LuisArturo
    ยท
    ยท

    Just to confirm this is exactly what your are looking for, do you have several write to table integrations and you only want them to run one after one after another in succession, waiting for the previous to finish before moving on to the next. If so, then a conditional formula can be used to make it that each write to table will wait for the previous one to finish running before starting to run on it own. Also could you post a link to the table where you are working on this so that we can take a look.