Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2009-12-29 07:18 PM

Address comparison for two seperate data sources

I'm loading an excel file into qlikview that has an address field such as "804 west George st". I'm wanting to compare this address to the database which also pulls into qlikview in a separate field. However, sometimes the address in the excel sheet will not be exact as the address in the db. I want to somehow pull the records that are "like" each other and display them.

Any suggestions on the best way to do this?

Thanks,

313 Views
0 Likes
1 Reply
prieper
Master II
Master II
‎2009-12-29 09:48 PM

Have you had a look at the Soundex-Algorithm? It may help so sort out some addresses, others might be checked by filtering the ZIP-codes, the first 8 letters etc.
In the past have solved similar issues more or less manually within Excel with refining VLOOKUPs.

Peter

109 Views
0 Likes