Help

How to show only one name, when there are duplicates

Topic Labels: Data
Solved
Jump to Solution
621 2
cancel
Showing results for 
Search instead for 
Did you mean: 
UrbnJ
4 - Data Explorer
4 - Data Explorer

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?

1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

Hi @UrbnJ,

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

Rollup Field - Overview | Airtable Support

See Solution in Thread

2 Replies 2
Sho
11 - Venus
11 - Venus

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.