Map text values
Mapping text values from the source data to specified text values or to a different hierarchy of terms involves a data transformation. For example, you can use mapping to do the following:
- Combine multiple adverse events from the source data into a single combined event.
- Specify that PTs from the source data should use a non-primary path for hierarchy values assigned by the application.
- Recode drug names from the source data.
The mapped values can be selected for use in an MGPS data mining run.
Note:
See Defining custom terms for another way of mapping values to a term that you specify for a data mining run. See Comparing custom terms and mapped text values for information on the differences between these features.To map text values, you use a text editor to create a file that contains the mappings and then you upload the file to a mapped variable in the configuration. To view the current mappings for a variable, edit the configuration, and for the mapped variable click View Current Mapping.
Note:
If you modify a mapping file, your changes are not applied automatically to the mapped variable. You must edit the configuration and upload the modified mapping file for the mapped variable.Text mapping process
Changing only the hierarchy
If you want to change only the hierarchy used for the old value, enter the same old and new value, and then the hierarchy value:
Generating results for mapped values
When creating a data mining run, choose the new variable. (Because you did not modify the original variable, that variable is also still available for selection.) Results are generated for combinations including the new value, as in the following example:
Note:
There might be more results for Insulin and the pre-mapped terms than for Insulin and the new mapping term because cases that include multiple pre-mapped terms are counted only once for the new mapping term.Parent topic: Transform data