Skip to main content
Solved

How to show only one name, when there are duplicates

  • December 14, 2023
  • 2 replies
  • 9 views

Forum|alt.badge.img+4
  • New Participant
  • 4 replies

Hello community!

I have a problem, which I've been unable to resolve myself.

I have two different tables, of which one table contains different entrees (table 1), which get combined in the other table in groups (table 2).

Now, in the first table (table 1) with different entrees all entrees have a name connected to it.
But in the other table (table 2) that groups these entrees the name should also be shown (rollup from table 1).

Now the problem is that the groups of tables exists mainly from entrees with the same name. And if I show the name through rollup, I see the name many times, not just one time. I would like to only show the name once if the entrees all contain the same name.
Hope my explanation is clear.

Does anyone know how to do this?

Best answer by Sho

Hi @UrbnJ,

Duplicates are removed using the ARRAYUNIQUE function.
This article is a helpful reference.

Rollup Field - Overview | Airtable Support

2 replies

Forum|alt.badge.img+21
  • Inspiring
  • 560 replies
  • Answer
  • December 15, 2023

Hi @UrbnJ,

Duplicates are removed using the ARRAYUNIQUE function.
This article is a helpful reference.

Rollup Field - Overview | Airtable Support


Forum|alt.badge.img+4
  • Author
  • New Participant
  • 4 replies
  • December 18, 2023

Hi @UrbnJ,

Duplicates are removed using the ARRAYUNIQUE function.
This article is a helpful reference.

Rollup Field - Overview | Airtable Support


Thanks for this solution. It works perfectly.