Forum Discussion
Need suggestions
hi guys, i have a table that contains city names in english and porteguese... like sao paulo-são paulo rows but they have same zipcode in total. how can i handle it? lots of city name and zipcode but i want to make it as one city name. what should i do? any suggestion? solution that i found is not so good(finding names and replacing via replace values)
or maybe i can apply the code like if zipcode is 10770 and this zipcode have two names make it one and apply for all rows
3 Replies
You can just add one table to your model with only English city names & zip codes and relate this to your present model with zip codes and make use of the city from this table only
1. You can avoid redundant data by using this way (instead of adding this to the main table)
Regards,
Ritesh
Hi, unallerhann
Depending on what language you want to use and also if it's somehow globally recognizable by some flag (Column with ENG for English etc.)
If you can't tell and you don'T care about which language is gonna be selected, you can just simply choose the Zip Code Column and remove duplicates (given you have only unique zip codes for each pair of cities).
Essentially, What I would try to do, is to somehow create a flag column, that would easily identify which language is used and then just filter out the language you don't need.
Maybe if you could show your model, we can try to identify how to add the language flag.Hi, these are the photos of model. I want to find the total sales as using cities not for states. But as i mentioned there is a problem sao paulo-são paulo(mentioned above).
