Help

Re: Duplicated Content in Lookup

Solved
Jump to Solution
709 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Casey_Martell
5 - Automation Enthusiast
5 - Automation Enthusiast

Has anyone seen duplicated content resulting from a Lookup?

I’ve noticed this in a couple different tables and it is causing formula errors for me.

For example, I have a lookup on a single select field with only these options: http://photoville.org/uploads/2020-08-05_073451_3zvyyjo.png

Yet, in the resulting field, there are sporadic entries that appear as ‘Clinical Trial, Clinical Trial’

When I subsequently attempt to use this field in a Switch(), I get ‘#ERROR!’ in those case where the entry is duplicated.

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

Welcome to the Airtable community!

Is the record with the duplicate content in the lookup linked to multiple records? More specifically, is it linked to multiple “Clinical Trials” records? A lookup field shows the lookup value for all of the linked records. If a record has two record links, the corresponding lookup would show two values, even if they are the same.

An alternative is to use a rollup field with the ARRAYUNIQUE(values) formula.

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

Welcome to the Airtable community!

Is the record with the duplicate content in the lookup linked to multiple records? More specifically, is it linked to multiple “Clinical Trials” records? A lookup field shows the lookup value for all of the linked records. If a record has two record links, the corresponding lookup would show two values, even if they are the same.

An alternative is to use a rollup field with the ARRAYUNIQUE(values) formula.

Thank you, that totally was the problem, and a nice solution!