Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

City Level information

Hello All,

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!


Former Member

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question