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:
" 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?
Try with SELECT(Students[First Name], TRUE,TRUE)
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.
Ah, now I see. Thanks for the explanation.
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |