函数 listContains() 可以计算一个列表中是否包含某个元素,并返回 1(是)、0(否)。
Arguments:
- 列表 <list>
- 元素 <any>
Returns:
- 1 或 0
一般用法
示例:异源别名直接计算
uncollect [[1,2,3],[2,4,5]] as a
uncollect [3,4] as b
return table(toString(a), b, listContains(a, b))
| toString(a) | b | listContains(a, b) |
|-------------|---|--------------------|
| [1,2,3] | 3 | 1 |
| [2,4,5] | 4 | 1 |
示例:异源别名笛卡尔积后计算
uncollect [[1,2,3],[2,4,5]] as a
uncollect [3,4] as b
with listContains(a, b) as c
return table(toString(a), b, c)
| toString(a) | b | c |
|-------------|---|---|
| [1,2,3] | 3 | 1 |
| [1,2,3] | 4 | 0 |
| [2,4,5] | 3 | 0 |
| [2,4,5] | 4 | 1 |