Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

To access this area, you need to have at least view permissions on Lookupsthe View version of the Lookups permission. However, you will not be able to upload files to create lookups unless you have the management version of that very same permission.

...

the Manage version is required to create lookups by uploading files.

Notice that at least the View version of the Finders permission is required to enable the Lookup permission (know more about permissions here).

...

What type of data can I use?

...

Rw ui steps macro
Rw step

In the Data search → Lookup management area, click New lookup at the top right.

Image RemovedImage Added
Rw step

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).

Rw step

Check the Contains headers box to specify that the first row must not be considered as values and thus must be skipped when parsed.

Rw step

Give each field the desired name and format, and then choose the desired key field by marking the Is key option at the end of its row.

Image RemovedImage Added
Info

Repeated values in the key field

The field 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.

In the example below, if you select user as key field, only the second event for Mike will be considered.

User, Count;

Mike, 23; Lisa, 423; Mike, 54; Lara, 21

Rw step

Click Create lookup. You will receive a notification when the file is uploaded. Note this may take a few minutes.

...