7,649
edits
Changes
Jump to navigation
Jump to search
→Create the keys
===Create the keys===
Standardize company names using Hall normalization without a fuzzy algorithm (see [[The Matcher(Tool)]]) and matching them to themselves for PortCos, M&As, IPOs. Then create keys for each table as follows:
*PortCo: Coname, statecode, datefirstinv
*M&A (private targets): targetname, statecode, announceddate
*IPOs: issuer, statecode, issuedate
