Changes

Jump to navigation Jump to search
48 bytes added ,  17:09, 6 August 2018
--28833
Since the count of fundbasecore is the same as the number of distinct fundnamesfund names, we know that the fundbasecore table is clean. In the first query I am finding duplicate rows and choosing the row that has the greater last investment date. I then match this table back to fundbasenound but choose all the rows from fundbasecore for which there is no corresponding fund in fundupsbased on fund name and date of last investment. This allows the funds with the earlier date of last investment to be chosen.
==Instructions on Matching PortCos to Issuers and M&As From Ed==
158

edits

Navigation menu