City Level information
I am new to Data Quality and currently trying to clean up our address information using DQ 3.2. We have a number of requirements to try and report on the city level information. For example sales by city.
Now here's the problem. Say they want to report on the city of Los Angeles. LA actually consists of a number of cities such as Beverly Hills, North Hollywood, Burbank etc. The word "Los Angeles" never appears anywhere in the address. We are doing this globally for all countries and I noticed a similar pattern in a number of other countries as well.
The big question: is there a field that i can select in the output of the address cleanse transform that actually gives me "Los Angeles"? Do note here that it should ideally apply for all countries. If this is possible, I could populate that in a separate field and have the users report on that field.
Thanks in advance!