Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
May 13, 2020 01:12 AM
Hi,
I’m trying to get unique text values using ARRAYUNIQUE but the result is returning duplicate entries.
I have a lookup column called airlines with the values: American, Delta, Southwest, Southwest
I want the result American, Delta, Southwest.
But ARRAYUNIQUE({Airlines}) still returns American, Delta, Southwest, Southwest
Any ideas?
Jun 30, 2020 11:00 AM
Hi @Erik_Paquet
Thanks for your post! Our hunch here is that there may be some small difference between the two “Southwest” values, perhaps a leading or trailing space.
If this isn’t the case, could you kindly reply with the field type that is being looked up, a screenshot of the lookup configuration, as well as the lookup values, so that we can get a better understanding of how to help?