Upload a lookup table

[ 1 What permissions do I need? ] [ 2 Creating the new upload lookup ] [ 3 Finding your uploaded lookup ]

Users with the necessary permissions can upload CSV files to create lookup tables.

To upload them, you need to do it in the Lookup Management tab of the Data Search area.

What permissions do I need?

To access this area, you need to have at least view permissions on Lookups.

However, you will not be able to upload files to create lookups unless you have the management version of that very same permission.

Creating the new upload lookup

Suppose you have the following CSV file containing printers' information and their corresponding IPs and addresses, which we want to use to create a lookup table to later use for data enrichment:

If you want to upload the file as a lookup:

In the Data Search → Lookup Management area, click New Lookup at the top right.
Enter a name for the lookup, such as IP_list, and drag the file onto the field (or click Browse and select the CSV file). Check the Contains headers box to specify that the first row must not be considered as values and thus must be skipped when parsed.
Choose the desired key column by marking the Is key option at the end of its row.
Click Create Lookup. You will receive a notification when the file is uploaded. Note this may take a few minutes.

Now you can add the required columns in your lookup table to a query. See Add lookup values to your query to learn how to do it.

Repeated values in the key column

The column selected as key upon the lookup definition should not contain repeated values. If so, only the last value in the file will be kept, and the rest of the events with that value repeated will be discarded.

For example, if you upload the following CSV and select the column user as key, only the second event that contains Mike will be kept.

Finding your uploaded lookup

Once uploaded, you can find the lookup in:

Data Search → Lookup Management. Here you can manage and edit lookup tables (visit this article to know more). The lookup table will be ready when the indicator in the Status column turns green.
Data Search → Explore Your Data. Select the tags in the finder my.lookuplist.<lookupname> to open lookups as data tables and apply operations as you would do with any other data table.