Remap Sets - Using a Set
Copyright © 2020 EarthSoft, Inc • Modified: 20 Feb 2020
The EQuIS remap tool facilitates management of reference and look-up 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.
Please note that EQuIS offers several additional options for handling analyte name synonyms, specifically 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.In the Find and Replace window, click the Remap tab.
3.If nothing is displayed in the list, you do not have a live connection to the database. In this case, click the "..." button to browse for a *.wxml file (saved from the EQuIS Professional workspace).
4.Select the row for the remap set you want to use (expand the 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.