Table of Contents | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...
Argument | Description | Data type | ||
---|---|---|---|---|
Lookup name mandatory | Choose the lookup you want to use to enrich your table. | string | ||
Key mandatory | Choose the table field you want to use to correlate with the lookup key field. | same as lookup key field | ||
Time | Choose the table timestamp you want to use to correlate with the lookup timestamp. It identifies the row with the highest timestamp in the lookup that is before the timestamp in your table. | timestamp | ||
|
...
hlurjson("Lookup_name", Key_field, TimeTimestamp_field)
The complete syntax with both the create field operator and the operation syntax is:
select hlurjson("Lookup_name", Key_field, TimeTimestamp_field) as new_field
Info | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Existing lookups required To perform these operations, it is necessary to have existing lookups ready for use (visit this article to get help uploading lookups and this article to get help creating query lookups). Syntax special considerations
|
...