Data harmonisation is a key part of preparing data for interpretation, and involves making text values consistent within a property.
Version: 1.9+ (Jan 2018)
Usage: Data --> Harmonise data for a property
How to use in practice
Data harmonisation looks to resolve inconsistent naming schema imposed onto a text property’s data content. This should be done either post import or if sample sets are not appropriately capturing the data requested.
Once you've entered the harmonisation dialogue you can search for any text property from the p:IGI+ property model. Once a property is selected, a grid, like the one above, will appear displaying all unique text string occurrences against the property in question on the left and proposed and summary harmonisation strings on the right. Any proposed harmonisation (shown by the Green Action Arrow) will not be implemented until the Apply button is selected.
Where a property has an associated code list, this is presented on the far right-hand side and is used to conduct a preliminary search and naming management proposal. This code list can be searched using the box atop the list and utilised in the Proposed mapping column via copy (Ctrl+C) & paste (Ctrl+V).
The entries in the associated code list are also aliased and where a data string is not an exact match, but a close match a list of suggested code list names will be provided (Yellow Triangle). If however you are happy with the original naming schema present then no further action is required. If you would like to accept the suggested name just check the Include? box on the far left-hand side.
Where a data string is not in the code list nor the accompanying alias list then no action is suggested. If however an edit is desired to the naming then manually insert the new name into the Proposed Mapping column and once accepted the Green Action Arrow will indicate the action will be accepted once Apply is selected.
Once harmonisation of a property is complete, a summary list can be copied to the clipboard for documentation in reports or presentations etc.
© 2023 Integrated Geochemical Interpretation Ltd. All rights reserved.