Alternative Way to Standardize Country Codes in Clay Table

·

Hello guys, how are you? I tought that clay always returned the country code in the country tab, but that is not hapening because I sometimes have "Italy" for example. I can't really use AI on this because it will be a lot of records.. Any other way to transform this to always country codes? Table example here

✅1

2 comments

· Sorted by Oldest

Clay Team
APP
·
·
Hey Pedro, great observation! Unfortunately, that's how they're being labeled or pulled when they're scraped. Will ask if this could be standardized.In the meantime, does the amount of countries vary much or is it just a select few? If it's just from certain regions, we could use the conditional formula generator to clean these up for those cases.
Pedro A.
·
·
I fixed this when sending to n8n with a code there. But pls in the future if you can assure this will always be a country code, it will be nice
✨1

Clay Team
APP
·
·
Hey Pedro, great observation! Unfortunately, that's how they're being labeled or pulled when they're scraped. Will ask if this could be standardized.In the meantime, does the amount of countries vary much or is it just a select few? If it's just from certain regions, we could use the conditional formula generator to clean these up for those cases.
Pedro A.
·
·
I fixed this when sending to n8n with a code there. But pls in the future if you can assure this will always be a country code, it will be nice
✨1