Table of Contents | ||||
---|---|---|---|---|
|
...
Lookup values are added to the virtual data table at query time, as new columnsfields. The original data tables are never modified.
A key value must be selected. This is the column field in the lookup table that has values that correspond to values in the data table. In our example, the key column field will be the column field containing the IP addresses, which exists both in the lookup table and original data table.
Lookup tables can be edited to add, change or delete information.
Use cases
Here are some common use cases that demonstrate how lookup tables can be used.
Converting codes into names
...
Source | Lookup table type | Description |
---|---|---|
External file | Upload | External lookup tables uploaded as a .csv file. External sources may include lists of values, geo-localizations, or extracts from a database. Learn here how to upload external data as a lookup table. |
Query data | Static query | These lookup tables are created using query data from a specified period of time. See Create a lookup table from a query to learn more. |
Dynamic query | These lookup tables are fed with new data events every 5 minutes. Rows with duplicated key values will be overwritten. See Create a lookup table from a query to learn more. | |
Time range lookup | Both static and dynamic query lookups can be created as a time range lookup. To create these lookups, you must choose a timestamp type column field that will dictate the lookup values to be inserted. That is to say, the same entry of your key column field must be matched with different results depending on the specified date. Learn more here. |
...