Changes

Jump to navigation Jump to search
379 bytes removed ,  10:17, 25 July 2018
==Process For Creating the PortCoExits Table==
Even if you manually checked the excel sheet for Warning Multiple Matches with the Hall warning, there still may be duplicates. Check this To get rid of these specify that a query where you join a table of only singular primary keys to the original table. That way you will have unique primary keys by running:construction.
SELECT COUNT(*) FROM(SELECT targetname, targetstate, announceddate FROM MAClean)a; --7206  SELECT COUNT(*) FROM(SELECT DISTINCT targetname, targetstate, announceddate FROM MAClean)a; --7189  SELECT COUNT(*) FROM(SELECT issuername, issuerstate, issuedate FROM IPOClean)a; --2146  SELECT COUNT(*) FROM(SELECT DISTINCT issuername, issuerstate, issuedate FROM IPOClean)a; --2141  As you can see, I still have duplicates in both the MAClean and IPOClean files. I ran an aggregate function to get rid of these duplicates: There are two companies that have the name Masspower in the MACleanNoDups MAClean file. One is written in all caps and will thus not be caught by the an aggregate function. I will select only the companies where the primary keys occurs once and join this to MAClean. I will then select needed info from MANoDps.
DROP TABLE MACleanNoDups;
CREATE TABLE MACleanNoDups AS
158

edits

Navigation menu