| Table of Contents | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...
Select Create field in the search window toolbar, then select the Lookups category, and choose the Lookup (hlut) operation from the dropdown (more info here). You need to specify four arguments (one of them optional):
Argument | Description | Data type |
|---|---|---|
Lookup name mandatory | Choose the lookup you want to use to enrich your table. | string |
Lookup field mandatory | Choose the lookup field you want to use to enrich your table. | string |
Key mandatory | Choose the table field you want to use to find matches with the lookup key field. | same as lookup key field |
Time mandatory | Choose the table timestamp you want to use to correlate with the lookup timestamp. It identifies the value with the latest timestamp in the lookup before the timestamp in your table. | timestamp |
...