Clay Icon
Join the Community
02 Support

Alternative Way to Standardize Country Codes in Clay Table

Avatar of Pedro A.Pedro A.
·
·

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

2 comments

  • Avatar of Clay Team
    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.

  • Avatar of Pedro A.
    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