220
edits
Changes
Jump to navigation
Jump to search
→Joining funds with roundline
==Joining funds with roundline==
There is a lot of mismatches between funds and roundline. After investigation, it seems that some of the fundnames were altered in the roundline data. We will need to fix the RoundOnOneLine.pl and Normalize.pl scripts to fix this issue. SELECT COUNT(DISTINCT fundname) FROM roundline1 WHERE undisclosedflag=0; --19677After fixing and reimporting the roundline into vcdb2 there are still 1,963 funds that appear in roundline that are not in fundbasecore.
SELECT countCOUNT(*) FROM ((SELECT a.fundname, b.fundname FROM (SELECT DISTINCT fundname FROM roundline1 WHERE undisclosedflag=0) AS A LEFT JOIN (select distinct fundname FROM fundbasecore) AS B ON a.fundname=b.fundnameWHERE b.fundname IS NULL)) AS tas r; --170891963
--Look at the ones that don't match
roundline1 WHERE undisclosedflag=0) AS A LEFT JOIN (select distinct fundname FROM fundbasecore) AS B ON a.fundname=b.fundname WHERE
b.fundname IS NULL;
SELECT COUNT(DISTINCT fundname) FROM roundline1 WHERE undisclosedflag=0;
--19091
SELECT count(*) FROM ((SELECT a.fundname, b.fundname FROM (SELECT DISTINCT fundname FROM
roundline1 WHERE undisclosedflag=0) AS A JOIN (select distinct fundname FROM fundbasecore) AS B ON a.fundname=b.fundname)) AS t;
--17128
SELECT COUNT(DISTINCT fundname) FROM fundbasecore;
