The EQuIS remap tool applies new reference or lookup value synonyms on data imports and exports while maintaining the original 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 the following areas.
•EQuIS Professional EDP for editing data prior to loading (in EDDs)
•EQuIS Professional Grid View:
oupdating existing data (in a table)
oremapping report output (with the exception of Analytical Results II)
EQuIS offers several additional options for handling alternate analyte names, namely the RT_MTH_ANL_GROUP_MEMBER.CHEMICAL_NAME field and the RT_ANALYTE_VAR table.
To start remapping, first populate the RT_REMAP and RT_REMAP_DETAIL tables to define a remap set.
To use a remap set to replace values in a grid, do the following.
1.Click Find 
.
2.Click the Remap tab in the Find and Replace window.
3.If the list is blank, there is no 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. |