A few ways to approach this. Here is one way. You would do the following in your Catalog table:
- Make sure your table has a RowID column.
- Create a multiple relation that matches the name with itself.
- Create a Single Value column that takes First->RowID from the relation column.
- Create an if-then-else column:
– If RowID is Single Value RowID, then Name
The if-then-else column should contain a list of unique names