Can you use
the recode function on the ?key? column to make the synonyms exactly the
same? Do this by selecting the ?Key? column, then from the Cols
pull-down menu select recode. A list of all the unique values in the column
will appear with a column were you can recode synonyms with a common
value. The merge will then be
straight-forward.
Regards,
Sean
From:
jmp-l-owner@lists.biostat.wustl.edu
[mailto:jmp-l-owner@lists.biostat.wustl.edu] On Behalf Of James T Metz
Sent: Wednesday, October 11, 2006 11:37
AM
To:
jmp-l@lists.biostat.wustl.edu
Cc: James T Metz
Subject: [jmp-l] Column matching using a
set of synonyms
JMP Users,
When updating a JMP table, it is necessary to choose a column "key" on which
to join
or merge the new data into
the old table.
Question. Suppose the "key" is sometimes specified using different words
or a set of
words which might be
considered as synonyms. Also assume that the synonym sets are
unique i.e. no
overlap.
Does anyone have any idea then how to match up two tables and update the "old"
table
with data from the "new"
table if I am using synonyms rather than exactly the same "key" as
in
the old data
table?
Regards,
Jim Metz
James T. Metz,
Ph.D.
Research Investigator Chemist
GPRD R46Y AP10-2
Abbott
Laboratories
100 Abbott Park
Road
Abbott Park, IL
60064-6100
U.S.A.
Office (847) 936 -
0441
FAX (847) 935 -
0548
james.metz@abbott.com
This communication may contain
information that is legally privileged, confidential, or exempt from
disclosure. If you are not the intended recipient, please note that any
dissemination, distribution, use, or copying of this communication is strictly
prohibited. Anyone who receives this message in error should notify the
sender immediately by telephone or return email and delete it from his or her
computer.