SELECT() documentation example issue

[ademoor]

Hi there, I just discovered AppSheet a few weeks ago, and feel like a kid in a candy store! What an incredible platform, have been looking for something like this for years.

I am going through the documentation now, and have a question about this example:

help.appsheet.com

SELECT()

Gather column values from row in table

" SELECT(Students[First Name], TRUE) : A list of first names (possibly with duplicates) of all students. Equivalent to Students[First Name] ."

I just can’t figure out why this expression would possibly result in duplicates. Doesn’t distinct-only? being TRUE mean that there should definitely be NO duplicates?