220
edits
Changes
Jump to navigation
Jump to search
→Cleaning fundbase
==Cleaning fundbase==
First flag the undisclosed funds.
CREATE TABLE fundbase1 AS
SELECT *, CASE
WHEN fundname LIKE '%Undisclosed Firm%' THEN 1::int
ELSE 0::int END AS undisclosedflag
FROM fundbase;
--27588
==Cleaning roundline==
