353
edits
Changes
Jump to navigation
Jump to search
FortunatelyThe postcode_city, postcode_addr1 and postcode_addr2 are consistent. The issue is the difference between postcode and (postcode_city, postcode_addr1, and postcode_addr2 and postcode are consistent except a few records). Examples:
Patent Assignment Data Restructure (view source)
Revision as of 16:59, 3 April 2017
, 16:59, 3 April 2017→Master Table
c. Postcode is the priority
Reminder: postcode_city is the postcode extracted from 'city'; postcode_addr1 is the postcode extracted from 'addrline1'; postcode_addr2 is the postcode extracted from 'addrline2'.
reelno | frameno | postcode | postcode_addr1 | postcode_addr2 | postcode_city | postcode_new
