220
edits
Changes
Jump to navigation
Jump to search
→Fixing Errors in the Matcher Output for portco and ipo
==Fixing Errors in the Matcher Output for portco and ipo==
After running the Matcher on your portcokeys and ipokeys you will notice there are some errors in the matched output file. Add flags in Excel that
DROP TABLE matcherportcoipo;
CREATE TABLE matcherportcoipo (
warning varchar(100),
file1coname varchar(100),
file1statecode varchar(2),
file1datefirstinv date,
file2issuer varchar(100),
file2statecode varchar (2),
file2issuedate date,
excludeflag1 int,
excludeflag2 int,
warningflag int
);
\COPY matcherportcoipo FROM 'matcherportco-ipos.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV
--2592
==Creating Stage Flags Table==
