...
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 |
...
