The EQuIS remap tool facilitates management of 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, users may have RT_MATRIX.MATRIX_CODE = SO for soil in the 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:
•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)
Note: EQuIS offers several additional options for handling analyte names, specifically the RT_MTH_ANL_GROUP_MEMBER.CHEMICAL_NAME field and the RT_ANALYTE_VAR table. |
To get started with remapping, first populate the RT_REMAP and RT_REMAP_DETAIL tables to define remap sets. See the Remap Sets – Creating a Set article in Professional for more detail.
To use a remap set to replace values, do the following:
1.Click the Find 
button on the Home ribbon.
2.In the Find and Replace window, click the Remap tab.
3.If nothing is displayed in the list, EDP does not have a live connection to the database (i.e., EDP Standalone). In this case, click the "..." button to browse for a *.xml file (saved from the EQuIS Professional workspace). See the Remap Sets – Saving to an External File article to learn how to export a remap file.
4.Select the row to use for the remap set (expand the row to see what values will be replaced).
5.Select which replacement option 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. •If there is a many-to-one mapping using a pipe-delimiter list, the entire pipe-delimiter list will be used. •If there is a many-to-one mapping for multiple records in the RT_REMAP_DETAIL table, the first value will be used.
|