I’ve mapped the other identifiers of my COs (Specimen No) in the field “Identifier” from Other Identifier table. However, when I search for these COs, I notice that the results are multiplied by the number of other Identifiers. For example, I only have one CO named DAVFP1, but the query returns two results because there are two other identifiers. The COs also appear twice on the map if I include the other identifiers in the query. Should I instead merge the other IDs before importing and map them to the “Other ID Remarks” field instead?
To get the results to appear in one row in queries you’ll just need to use the (aggregated) value in the query. If you’ve never set up a table aggregation, we have documentation on it here! Creating a table aggregation will combine all the records into a single string so only one row is returned instead of multiple.
Query results using the Other Identifier Identifier field:
