Rearranging Column Orders and Dependencies Without Data Loss

Nick Singh · 2024-02-28 09:35:24.332676+00

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 :man-facepalming:

Rearranging Column Orders and Dependencies Without Data Loss | Clay

8 comments

· Sorted by Oldest

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 😉
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🙏🏽
Nick Singh
·
·
https://app.clay.com/workspaces/207112/tables/t_FOsoEHuQCF4Q/views/gv_cHw3v66dn7Mo
Nick Singh
·
·
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
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?
Nick Singh
·
·
yes correct, also might have to check the dependencies if any on the neverbounce columns
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)
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

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 😉
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🙏🏽
Nick Singh
·
·
https://app.clay.com/workspaces/207112/tables/t_FOsoEHuQCF4Q/views/gv_cHw3v66dn7Mo
Nick Singh
·
·
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
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?
Nick Singh
·
·
yes correct, also might have to check the dependencies if any on the neverbounce columns
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)
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