158
edits
Changes
Jump to navigation
Jump to search
→Process For Creating the PortCoExits Table
==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. To get rid of these specify that I wrote a query where you join a table of that only singular includes primary keys to the original tablethat occur once and matches them against MANoDups. That way you will have unique primary keys by construction.
There are two companies that have the name Masspower in the MAClean file. One is written in all caps and will thus not be caught by 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.
