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;
--19677
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;
--17089
--Look at the ones that don't match
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.fundname WHERE
b.fundname IS NULL;
SELECT COUNT(DISTINCT fundname) FROM fundbasecore;
--27044
SELECT count(*) FROM ((SELECT a.fundname, b.firmname FROM (SELECT DISTINCT fundname, firmname FROM
fundbasecore) AS A JOIN (select distinct firmname FROM firmbasecore) AS B ON a.firmname=b.firmname)) AS t;
--26910
SELECT COUNT(DISTINCT firmname) FROM fundbasecore;
--14103
SELECT count(*) FROM ((SELECT a.firmname, b.firmname FROM (SELECT DISTINCT firmname FROM
firmbasecore) AS A JOIN (select distinct firmname FROM fundbasecore) AS B ON a.firmname=b.firmname)) AS t;
--14084
==Creating portcoexitmaster==
