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 DISTINCT issuer, issuedate,statecode FROM ipocore)a;
--9470
Next export the keys to a text file and put in the Matcher input folder. Run the matcher on these files. For instructions on how to use the Matcher check this out [[The Matcher (Tool)]]
==Fixing Errors in the Matcher Output for portco and ipo==
