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?

[Aleksi]

Try with SELECT(Students[First Name], TRUE,TRUE)

[Steve]

The second argument to SELECT() is an expression that matches the desired rows. In the example, the second argument–the row-matching expression–is the trivial expression, TRUE, which always matches. It’s the third argument–which isn’t present in this example–that enables district-only values.

The point of the example is to show the equivalency between the two expressions, both of which return a list of all values in a chosen column.

[ademoor]

Ah, now I see. Thanks for the explanation.