ctackett6407
Board Regular
- Joined
- Mar 18, 2018
- Messages
- 66
- Office Version
- 365
- Platform
- Windows
Greetings Everyone!
I've been learning a lot since I have been a part of this community and I want to say thank you!
I have another question that I'm going to go in and try what I know and see how that goes, but if someone has a better suggestion, I'm all ears!
We currently have three different sources of data. They do not work well with each other; however, I think if we can tie a standard data set between them then it will be a GREAT tool for us to use.
I just exported one of the sources moments ago and found it has around 60k rows of data in it. I'm trying to compare addresses from one file to addresses I pull from our primary data source and try to see if I can compare those. That's the only thing I can see that MAY be comparable.
The problem is that the addresses from the two sources I want to compare may be spelled a little different or use "west main street" or "w main st" etc.. variants.
I might try to compare the county and the zip code as well to ensure that if the service address matches that it "really" matches because there's only one address in a city, as far as I know.
I have not seen several addresses of 123 Main Street in the same zip code.
Anyway, Anyone knows or where I can learn more about trying to create a formula that will let me search addresses that might have variants in it?
I've been learning a lot since I have been a part of this community and I want to say thank you!
I have another question that I'm going to go in and try what I know and see how that goes, but if someone has a better suggestion, I'm all ears!
We currently have three different sources of data. They do not work well with each other; however, I think if we can tie a standard data set between them then it will be a GREAT tool for us to use.
I just exported one of the sources moments ago and found it has around 60k rows of data in it. I'm trying to compare addresses from one file to addresses I pull from our primary data source and try to see if I can compare those. That's the only thing I can see that MAY be comparable.
The problem is that the addresses from the two sources I want to compare may be spelled a little different or use "west main street" or "w main st" etc.. variants.
I might try to compare the county and the zip code as well to ensure that if the service address matches that it "really" matches because there's only one address in a city, as far as I know.
I have not seen several addresses of 123 Main Street in the same zip code.
Anyway, Anyone knows or where I can learn more about trying to create a formula that will let me search addresses that might have variants in it?