The EQuIS remap tool facilitates managing reference and lookup value synonyms on both import and export of data while maintaining the single core set of reference values defined in the EQuIS Database. For example, you may have RT_MATRIX.MATRIX_CODE=SO for soil in your EQuIS Database, but be required to report using MATRIX_CODE=SOIL to comply with the specific criteria of a regulatory agency or project. The remap tool is available in EDP for editing data prior to loading as well as in EQuIS Professional for updating existing data or remapping report output.
Note that EQuIS offers several additional options for handling analyte name synonyms, namely the RT_MTH_ANL_GROUP_MEMBER.CHEMICAL_NAME field and the RT_ANALYTE_VAR table.
To get started with remapping, first populate the tables to define remap sets.
To use a remap set to replace values, do the following.
1.Click the Find 
button.
2.Click the Remap tab in the Find and Replace window.
3.If nothing is displayed in the list, then you do not have a live connection to the database. In this case, click the "..." button to browse for a *.wxml file (saved from EQuIS Professional workspace).
4.Select the row for the remap set you want to use (expand row to see what values will be replaced).
5.Select which replacement option you want to use (EXTERNAL_VALUE replaced by INTERNAL_VALUE or INTERNAL_VALUE replaced by EXTERNAL_VALUE).
6.Click the Remap button to execute the remap.
Warning: Remapping applies to all tables or sections allowed in the remap set, regardless of whether the table/section is open while the remap is executed. It is impossible to undo a remap. The internal-external replace order can be reversed, but this will not work if there are many-to-one mappings. |