- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 12, 2024 04:28 AM - edited Aug 12, 2024 04:29 AM
Hello Airtable Community,
I've set up a table with a significant amount of information and data. In a second table, I’m pulling in information from the first using linked records/LookUp. However, I’ve noticed that the same item is being repeated within the same record in this second table.
Has anyone else encountered this issue? Any suggestions on how to prevent these duplicates and ensure that each item only appears once in a record would be greatly appreciated!
Thanks in advance for your help!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 12, 2024 06:31 AM
Hello,
I guess that is due to the fact that different scenes have the same information (for example scenes 1.2, 1.3 and 1.4 all refer to episode 1).
In order to get unique values in your "Day" table, you can use a Rollup field with the formula ARRAY_UNIQUE(values) instead of a lookup field:
Regards,
Pascal
