...
To perform a simple extraction of values without conditionals, use the LIST function. See LIST Function.
D s | ||
---|---|---|
|
d-codelang-syntax | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
| LISTIF
| |||||||||
listif(hotChocolateLiters, 500, temperature < 0) |
Output:
...
Returns the values from the hotChocolateLiters
...
column when the temperature
value is less than 0. Maximum number of values is 500.
...
D s | ||
---|---|---|
|
d-code | ||||||||
---|---|---|---|---|---|---|---|---|
-lang-syntax | ||||||||
| ||||||||
listif(col_ref, limit, test_expression) [group:group_col_ref] [limit:limit_count] |
Argument | Required? | Data Type | Description |
---|---|---|---|
col_ref | Y | string | Reference to the column you wish to evaluate. |
limit_int | N | integer | Maximum number of values to extract into the list array. From 1 to 1000 . |
test_expression | Y | string | Expression that is evaluated. Must resolve to true or false |
...