Versions Compared

Key

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

...

Name

Data type

Name

Data type

Alphanumeric value

String

Hexadecimal number

Hex4

Integer number

Int4

Long hexadecimal number

Hex8

Long integer number

Int8


IPv4 address


IP4

Floating point number

Float4

IPv6 address

IP6

Net4 (IPv4 CIDR)

net4

Net6 (IPv6 CIDR)

net6

Info

Data type translations

As a result of standardization procedures, some of these data types are translated when the lookup in created. Hexadecimal, for example, will be shown as Int.

...

Rw ui steps macro

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.

Note

Not allowed characters

Note that the following characters are not allowed in the lookup field names:

= % / @ & " ' < >

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

...