Variants of the same address
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22651
Printed Date: 02 May 2024 at 1:53pm
Topic: Variants of the same address
Posted By: GPDJJ
Subject: Variants of the same address
Date 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?
|
Replies:
Posted By: hilfy
Date 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.
-Dell
-------------
Proviti, Data & Analytics Practice
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics
|
Posted By: GPDJJ
Date Posted: 02 Aug 2018 at 12:46pm
|
Yeah I was afraid of that. I was hoping for a bail out from a formula. Oh well. Thank you.
|
|