Page Comparison

...

Users with the necessary permissions can upload CSV files to create lookup tables. To upload them, you need to do it in the Lookup Managementmanagement tab of the Data Searchsearch area.

...

What permissions do I need?

...

Rw ui steps macro

Rw step In the Data Search → search → Lookup Managementmanagement area, click New Lookuplookup 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 Lookuplookup. You will receive a notification when the file is uploaded. Note this may take a few minutes.

...

Once uploaded, you can find the lookup in:

• Data Searchsearch → Lookup Managementmanagement. 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 field turns green.

• Data Searchsearch → Explore Your Datayour 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.

...