Versions Compared

Old Version 49

changes.mady.by.user Borja Moro Moreno

Saved on

compared with

New Version 50

changes.mady.by.user Borja Moro Moreno

Saved on

Key

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

...

Rw ui steps macro
Rw step

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

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.

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.

Now you can add fields from your lookup to a query in order to enrich it with additional information. See Add lookup values to your query to learn how to do it.

Finding your uploaded lookup

...