Rollup Field ArrayUnique is not giving me fully unique values. How can I fix this

[Zach_Ruben]

Hey All! I am using a rollup field with the function ARRAYUNIQUE() in hopes of getting unique values but am still getting duplicates.

I have a base with partners and markets, and I want to show all of the partners available in each market. However, when I rollup the values from the market table, I am getting duplicate values. (i.e. if Boston and Chicago both have same partner, then the unique rollup is showing that partner twice. Is there a way to fix this? Does my question make sense? Thank you so much for any help!!

[ScottWorld]

Check out this thread and see if this helps solve your issue:

Removing duplicates from a string Formulas

Using ARRAYFLATTEN can be tricky. When using it in a rollup to count unique items across lin with linked records, you need to use it in a rollup of a lookup, not a rollup of a linked record field. [image] ARRAYUNIQUE(ARRAYFLATTEN(values)) I tried to search these forums for the thread where this particular use case was explained to me to give credit, but I couldn’t find it. Note that ARRAYUNIQUE(ARRAYFLATTEN(features)) works differently, depending on what type of field is being rolled up.

[Karlstens]

I too have just hit this issue, but am tying my base in knots trying to cater for the ArrayFlatten formatting by adding rollup/lookup fields that don’t appear to be addressing the issue.

Can anyone provide a simple example, where multiple people are being assigned to a task, and in the task summary there’s a field that’s rolling up the names of assigned people - but with duplicates removed. A couple of screenshots would be helpful too.

I was following the thread with the super heroes example, but the solution given didn’t really detail the super hero base and referred to a colours base, and now I’m just confused and I want to be rid of my duplicate multi-select lookups. :sob:

[ScottWorld]

Check out these 2 threads and see if they help solve your issue. @Adam_Minich created a video in the first thread:

Remove duplicates in look up field Ask the community

Hello community! Adam from the Airtable customer support team here. I had an Airtable user reach out with a link to this community post. While I can’t speak to a specific timeframe for when this feature might be available I have a workaround that may help. I used the Recipe, Ingredients, and food type example from earlier in the thread. Also, you will need to have some comfort with our Automations feature in order to use this method: Hope this helps and know that our team is ver…

Removing duplicates from a string Formulas

Using ARRAYFLATTEN can be tricky. When using it in a rollup to count unique items across lin with linked records, you need to use it in a rollup of a lookup, not a rollup of a linked record field. [image] ARRAYUNIQUE(ARRAYFLATTEN(values)) I tried to search these forums for the thread where this particular use case was explained to me to give credit, but I couldn’t find it. Note that ARRAYUNIQUE(ARRAYFLATTEN(features)) works differently, depending on what type of field is being rolled up.

[Karlstens]

Thanks @ScottWorld - I suspect I’ll find the method needed within this base too;

Airtable

🎥 Filmshoot demo - Airtable

Explore the "🎥 Filmshoot demo" base on Airtable.

Would be great if Airtable Devs could resolve this problem with another aggregation function - it would make life so much easier.