I have downloaded the Australian G-NAF Dataset and was hoping that someone here was familiar with it and how to validate my customer file against G-NAF File, I thought I could build a matchkey based on address and postcode information but unfortunately this only gave me a 10% match rate when the G-NAF file is almost all of Australia 14.5 million records. I have created a table from the 30 odd tables which make up the G-NAF DATsets condensing down to the list below under G-NAF File listing
the fields I need to match against are as follows,
I just need to run my client file against the G-NAF and append the matched information but if we could incorporate the wildcard to allow for certain mis-spelling but making sure the postcode filed is not wildcarded, so how do I run a query against each of the fields from my client file to the G-NAF file without merging fields?
hopefully someone has experience of this!!
many thanks in advance