Hi Siraj -
Tableau doesn't support Fuzzy Matching / Lookup like you might find in an ETL tool, sorry. You'll need to do this work outside of the tool then report the results of the task using Tableau.
Thanks Russel for the clarification.
1 of 1 people found this helpful
I recommend using ISO names rather than local derivatives. I know this may come a little late for your dB schema design, but there is a reason for this; namely forward and reverse geocoding. If you have the ability, ask your DBA to set up a trigger for going forward.
You could maybe use this to help pre-process.
Sorry I can't be more help.
Thanks a lot Allan for the suggestion. I will consider this approach and see what we can do, going forward.
And thanks a lot for the link to the Excel add-in - I did not know about this before. Very helpful. I can do some preprocessing using this Add-in and then bring the result to Tableau, I hope.
You're more than welcome. If someone can be bothered reverse engineering that add-in, then we could bring the capability of fuzzy matching to Tableau. One for the ideas forum I think!