...
Related articles: Detection group
Lookup operations
Queries to use lookup operations present some particularities that make them incompatible when used from the search window to Activeboards or vice versa. The use of symbols is different and the domain name is required in one of them.
...
Search window
...
Activeboards
Syntax:
select `lu/lookupName/lookupfield`(field) as newfieldName
Query example:
| Code Block |
|---|
from demo.ecommerce.data
select `lu/IP_list/StreetAddress`(clientIpAddress) as `IP street address` |
...
Syntax:
select lu("lookupName", "lookupfield", field) as newfieldName
Query example:
| Code Block |
|---|
query(from demo.ecommerce.data
select lu("IP_list", "StreetAddress", clientIpAddress) as `IP street address`) |
Related article: Data enrichment
Maximum (max) operations → create field
...