Joined: 07 May 2018
Online Status: Offline
Posts: 6
Topic: Variants of the same address Posted: 31 Jul 2018 at 5:31am
So I have a report where people have inputted the same address in various ways. I need to total them or count them as the same address is there a simple formula for that? They show as different address due to the space prior to the semi-colon.
4350 SOUTHWEST DR; Walmart
and
4350 SOUTHWEST DR ; Walmart
Now can I do this for all address variants that may come up for all address not just the one in the example?
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 02 Aug 2018 at 3:55am
This is more of a data quality issue than a reporting issue. Odds are that you're not going to be able to handle all variants of an address in the report.
Depending on how much control you have in the database, you might want to look at creating a stored procedure that will go through the address data in the database and cleanse it before it gets to the report. If you're reporting off of a data warehouse, then part of the ETL process should be to cleanse and format this data.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
