Dec 14, 2023 03:25 AM
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?
Solved! Go to Solution.
Dec 15, 2023 04:28 AM
Hi @UrbnJ,
Duplicates are removed using the ARRAYUNIQUE function.
This article is a helpful reference.
Dec 15, 2023 04:28 AM
Hi @UrbnJ,
Duplicates are removed using the ARRAYUNIQUE function.
This article is a helpful reference.
Dec 18, 2023 03:21 AM
Thanks for this solution. It works perfectly.