Understand the Considerations for the Lookup List File

The CSV file for your lookup list must meet the following requirements:

• The first row must be a comma-separated list of field names.
• The field names cannot exceed 40 characters. The names can only contain alphanumeric characters and underscores. They must start with an alpha character.

• For search operations, the corresponding data types for lookup lists with variable characters (or varchars) are short text (VarShort) and long text (VarLong).

• The remaining rows must be comma-separated values for the fields in the first row.
• Do not include spaces before, after, or within a field name.
• All rows must contain the same number of values.
• You must select one of the columns as the key field, and the values of the key field must be unique.
• The key field is the field that you can use with the in list operator in queries.
• The file cannot exceed 25 fields and 2 million rows.
• The file cannot exceed 150 MB.