Versions Compared

Key

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

...

When creating a new upload lookup, the maximum size allowed recommended for the CSV file you intend to upload is 100MB and it may contain data in the formats listed below. Data in other formats will not be recognized and thus not offered as an option to choose in the lookup creation window. Visit Data types in Devo for examples on each data type format.

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

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

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.

...