Create a Lookup List

1. Select Configuration > Lookup Lists.
2. Click Add.
3. Drag-and-drop your CSV file to the Lookup Lists page or select Browse to navigate to the file.

4. Specify a name for the lookup list.
   

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

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

5. Specify the key field, then 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

6. To upload the file as a table in the database, click Upload.