220
edits
Changes
Jump to navigation
Jump to search
→Name Based Matching companybase keys to mas keys
Put the portcokeys and maskeysdatefiltered text files into the Matcher Input folder. For more instructions on how to run the Matcher see [[The Matcher (Tool)]]
You will still receive multiple warnings in the output.matched file. In Excel add flags to exclude if the announceddate < datefirstinv and another exclude flag if the datefirstinv = announceddate. Also add a warning flag if the Warning column is "Hall-Warning:Multiple". Then import this back into your db by creating a matcheroutput table.
DROP TABLE matcherportcomas;
CREATE TABLE matcherportcomas (
warning varchar(100),
file1coname varchar(100),
file1statecode varchar(2),
file1datefirstinv date,
file2targetname varchar(100),
file2targetstatecode varchar (2),
file2announceddate date,
excludeflag1 int,
excludeflag2 int,
warningflag int
);
\COPY matcherportcomas FROM 'matcheroutputportco-mas.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV
--9645
==Creating Stage Flags Table==
