ARRAYUNIQUE not working

[Erik_Paquet]

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?

[Joe_H]

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?