220
edits
Changes
Jump to navigation
Jump to search
→Name Based Matching companybase keys to ipo keys
==Name Based Matching companybase keys to ipo keys==
First verify that your keys in companybasecore and ipocore are unique by using the following queries. If not following instructions in these sections [[#Cleaning the Companybase table|Cleaning the Companybase table] and [[#Cleaning ipos table|Cleaning ipos table]]
SELECT COUNT(*) FROM companybasecore;
--44740
SELECT COUNT(*) FROM
(SELECT DISTINCT coname, statecode, datefirstinv FROM companybasecore)a;
--44740
SELECT COUNT(*) FROM ipocore;
--9470
SELECT COUNT(*) FROM
(SELECT DISTINCT issuer, issuedate,statecode FROM ipocore)a;
--9470
==Fixing Errors in the Matcher Output for portco and ipo==
