Create a Lookup List

  1. Select Search > Home > Lists > .
  2. Click +.

  3. Specify a name for the lookup list.

    Once you have added the lookup list, you cannot change the name of the list. The name must meet the following requirements:

    • Does not exceed 20 characters
    • Contains only alphanumeric characters and underscores
    • Starts with an alpha character

  4. To specify the CSV file, complete ONE of the following actions:

    • Drag and drop the file to the Lookup Lists page.

    • Select Choose File to navigate to the file.

  5. Click Continue.
  6. Specify the Field Name from your CSV file that will represent the key field.

  7. For the Value Type, either accept the recommended value type or specify a different one.

    The following are possible values:

    Value Type

    Specifies

    domain

    The name of the lookup list

    float

    A number whose radix point can be placed anywhere relative to the significant digits of the number

    hostname

    Fully qualified domain name

    int

    Integer value

    ipv4

    IPv4 address

    ipv6

    Ipv6 address

    mac

    MAC address

    short text

    Text that cannot exceed 1K of space

    long text

    Text that cannot exceed 4K of space

    time

    Time stamp

    url

    A URL address that cannot exceed 4K

    username

    A string type
  8. To upload the file as a table in the database, click Upload.