Clay Icon
Join the Community
02 Support

Rearranging Column Orders and Dependencies Without Data Loss

Avatar of Nick S.Nick S.
·
·

What's the best way to rearrange column orders and dependencies without losing the data? I think it would be to export all the data but that would mean that all the data would have to be visible on the table and I don't think I have enough columns for that 🤦‍♂️

8 comments

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Hey Nick, thanks for reaching out! Can you share an example of what you want to rearrange in your table? Changing the order and dependency will likely render already enriched data stale, which will cause the enrichments to need to be run again. If you can share an example and your table url, I'll take a look and see if there's a workaround🙏🏽

  • Avatar of Nick S.
    Nick S.
    ·
    ·

    the snov enrichment from the custom waterfall needs to move last as I only have the free credits and the IcyPeas enrichment needs to move after the Nimbler enrichment

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Thanks for sharing! Just to confirm the new order arrangement. I noticed you have 6 email enrichments: - Nimbler - Icypeas - Findymail - Prospeo - DropContact -SnovIs this the order you want the dependencies set to?

  • Avatar of Nick S.
    Nick S.
    ·
    ·

    yes correct, also might have to check the dependencies if any on the neverbounce columns

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Alright, I have updated your conditional formulas to follow this order. Current order is-Datagma -Nimbler - Icypeas - Findymail - Prospeo -DropContact - SnovFor future, you can use the waterfall enrichment to set up this structure. It provides options to add your API keys were needed and also use Neverbounce as the validation tool.Let me know if this helps!

    803a297b-4c05-40f1-be87-acc80877d335.png(184 kB)
  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Also, none of those columns have re-run so the data is currently still there. However, if your run them again, it will use the new dependencies and replace those cells with new data. A workaround for this (If you still want to run new rows) is: To filter by the new cells you want to run and only run the enrichments within that view, only running rows that haven't run before.

    👍1
Rearranging Column Orders and Dependencies Without Data Loss | Clay