topic Address comparison for two seperate data sources in QlikView https://community.qlik.com/t5/QlikView/Address-comparison-for-two-seperate-data-sources/m-p/198095#M57519 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>Any suggestions on the best way to do this?</P><P></P><P>Thanks,</P><P></P></BODY></HTML> Wed, 30 Dec 2009 00:18:15 GMT 2009-12-30T00:18:15Z Address comparison for two seperate data sources https://community.qlik.com/t5/QlikView/Address-comparison-for-two-seperate-data-sources/m-p/198095#M57519 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>Any suggestions on the best way to do this?</P><P></P><P>Thanks,</P><P></P></BODY></HTML> Wed, 30 Dec 2009 00:18:15 GMT https://community.qlik.com/t5/QlikView/Address-comparison-for-two-seperate-data-sources/m-p/198095#M57519 2009-12-30T00:18:15Z Address comparison for two seperate data sources https://community.qlik.com/t5/QlikView/Address-comparison-for-two-seperate-data-sources/m-p/198096#M57520 <HTML><HEAD></HEAD><BODY><P>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.<BR />In the past have solved similar issues more or less manually within Excel with refining VLOOKUPs.</P><P>Peter</P></BODY></HTML> Wed, 30 Dec 2009 02:48:54 GMT https://community.qlik.com/t5/QlikView/Address-comparison-for-two-seperate-data-sources/m-p/198096#M57520 prieper 2009-12-30T02:48:54Z