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.