353
edits
Changes
Jump to navigation
Jump to search
So If we relax the requirements for postcode, and we 'll get clean data (city that is a city, state that is a state) stored in ptoassigneend_us_identify4. SQL code:
Patent Assignment Data Restructure (view source)
Revision as of 11:02, 2 May 2017
, 11:02, 2 May 2017→Identify Clean Data (Round 2)
FROM ptoassigneend_us_postex;
===Identify Clean Data (Round 2Two)===
A new list of city is extracted in Section 4.3.2. This list, combined with 'ptoassigneend_us_citylist', creates a new city list 'ptoassigneend_us_citylist2' which can be used to identify clean data.
Remaining records are in table ptoassigneend_us_temp4.
One reason problem for the REMAINING records is that the postcode is missing.
CREATE TABLE ptoassigneend_us_identify4 AS
SELECT *
