In the Name field, enter the name of the variable.
Variable names display throughout the application, including when users
select criteria for viewing data mining results, defining queries, or
creating report definitions. For example, a column might be named SYMPTOM in
the Oracle table, but renamed to appear as Event in the application.
In the Description field, type a description of the
variable.
Next to the Table field, click Select
Table/Column.
As the Column of source data, select the drug or event variable
containing values that you want to map. The source column must be a text
value.
In the Prefix field, enter a prefix.
From the Variable Type drop-down list, select
Event or Drug.
Do not check Use as subset variable
or Use as stratification variable.
Optionally,
set up the mapped variable to use a hierarchy.
Set Hide From Query Wizard to
Yes. (Even if this setting is set to
No, the mapped variable is not available in the Query
Wizard.)
In the Data Transformation section, click
Text mapping, and then click Upload
Table.
From the Upload Text Map CSV File dialog box, next to
the File to Upload field, click
Browse.
Select the mapping file and click Open. The mapping file
must be in the format described in Map text
values.
Click Upload.
To make sure the mappings are correct, click View Current
Mapping.
If you map a variable in a configuration for which there are existing runs
that use the variable, users cannot drill
down correctly in the run results until the runs are
re-executed.