Hi, I have a field where I asked users to type in their country some of them I typing ‘United Kingdom’ others are typing ‘England’. Some of them are writing ‘United States’, others are typing ‘US’. Is there a way join this data?
Hi @vincentag
If you allow manual user input, then you essentially got free-style-text, which can easily be categories by a human, but it’s difficult for a computer.
You would either need to cleanup your data manually, and make sure you don’t allow free-style anymore.
Or write a query with a lot of CASE WHEN's that changes the returns your preferred format.
You can probably find better help on stackoverflow.com or similar sites, since this isn’t related to Metabase.
Alright, thank you flamber for your quick response.