Using Identifier in OtherIdentifier table correctly

Hi @Amelie,

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:

Query Results using the Other Identifier aggregation:

Let me know if this helps or if you have any other questions!