Using tags but seeing entries for every instance

[Danny_hearn]

Hi there,
I’m using tags in a table to create groups for records e.g. ‘homepage’ , ‘landingpage’ ‘checkout’ . In a one to many relationships.

So, for instance, I have a table that has

Observations | Tags
record 1 | Homepage
record 2 | Homepage
record 3 | Landing page

Then in another table I’m seeing

Insight | Observations | tags
Name | record1, record, 2 | Homepage, Homepage

What I want is it to do

Insight | Observations | tags
Name | record1, record, 2 | Homepage

When I do a lookup on the tags on a separate table. What I see is a record with the same tag repeated several times as it is linked to several other records. How can I make it only display an associated tag once rather than for every instance?

[Mohamed_Swella1 · Accepted solution]

Hi @Danny_hearn,

Welcome to Airtable Community !

Instead of Lookup use Rollup and in the Aggregation formula use ArrayUnique

BR,
Mo

[Danny_hearn]

Mohamed_Swellam:

ArrayUnique

Thank you! that worked perfectly