Remap Sets - Creating a Set

<< Click to Display Table of Contents >>

Remap Sets - Creating a Set

Using the EQuIS remap tool, you can manage synonyms on both import and export of data. It is possible to define as many different remap sets as desired by giving them each a unique REMAP_CODE. For example, there may be different remap sets for different types of EDDs, different data submitters, different projects, etc.

 

The first step is to create one or more remap sets that will be used for replacing values. A remap set consists of the tables that define the value-to-value mappings. To create a remap set, do the following:

1.Open EQuIS Professional.

2.Click the Reference Tables button.

3.Open the RT_REMAP table.

4.Add a new row (it is also possible to optionally populate other fields):

REMAP_CODE = "<name of remap set>".

REMAP_DESC = "<description of remap set>".

STATUS_FLAG = "A".

5.Save new row in the RT_REMAP table.

6.Open the RT_REMAP_DETAIL table.

7.Add a new row for each value-to-value mapping as follows:

REMAP_CODE = "<name of remap set>".

EXTERNAL_FIELD = "<table or format section name>.<fieldname>" (e.g., "rt_matrix.matrix_code or EFW2FSample.sample_matrix_code"). or use the asterisk as a wildcard to apply the remap to all tables/sections that include the target field (e.g., *.test_type):

EXTERNAL_VALUE = "<external value>" (such as "GW"). As of v5.6.4, to specify multiple external values, one can use the pipe delimiter ( | ) to separate the values (e.g., "GW|Groundwater|GrndWtr").

INTERNAL_VALUE = "<internal value>" (such as "WG")

8.Save the new row(s) in the RT_REMAP_DETAIL table.

 

Notes:

The wildcard "*" format is required for remapping report output.

In the RT_REMAP_DETAIL table, the combination of external_field, internal_value and remap_code values must be unique.

 

Once the remap set(s) is complete, the remapping may be applied by selecting the Find option in EDP or Professional. See complete steps in Remap - Set(s) - Using a Set.