Skip to main content
Solved

Duplicated Content in Lookup

  • August 5, 2020
  • 2 replies
  • 63 views

Forum|alt.badge.img+2

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.

Best answer by kuovonne

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.

2 replies

kuovonne
Forum|alt.badge.img+29
  • Brainy
  • Answer
  • August 5, 2020

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.


Forum|alt.badge.img+2
  • Author
  • New Participant
  • August 5, 2020

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!