Creating a Lookup File

Back to Lookup Files

See Also:Editing Lookup Data

The Lookup File is read-only data that helps the display or helps process the Capture file.

Lookup files can be created two ways:

Once created, if you need to import a CSV file one time (but not again), select the Import CSV File Button.

Clicking the Add button or double clicking on a Field Name will bring up the Add/Edit Field dialog.

Here you can rename the Lookup field.

Additional Notes:

There are some limitations to what names can be used in the Capture and Lookup Fields.

The following names are forbidden:

ABORT, AFTER, ALL, ALTER, AND, AS, ASC, ATTACH, AUTOINCREMENT, BEFORE, BEGIN, BETWEEN, BY, CASCADE, CASE, CHECK, COLLATE, COMMIT, CONFLICT, CONSTRAINT, CREATE, CROSS, CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, DATABASE, DEFAULT, DEFERRABLE, DEFERRED, DELETE, DESC, DETACH, DISTINCT, DROP, EACH, ELSE, END, ESCAPE, EXCEPT, EXCLUSIVE, EXPLAIN, FAIL, FOR, FOREIGN, FROM, FULL, GLOB, GROUP, HAVING, IGNORE, IMMEDIATE, IN, INDEX, INITIALLY, INNER, INSERT, INSTEAD, INTERSECT, INTO, IS, ISNULL, JOIN, KEY, LEFT, LIKE, LIMIT, MATCH, NATURAL, NOT, NOTNULL, NULL, OF, OFFSET, ON, OR, ORDER, OUTER, PRAGMA, PRIMARY, RAISE, REFERENCES, REINDEX, RENAME, REPLACE, RESTRICT, RIGHT, ROLLBACK, ROW, SELECT, SET, STATEMENT, TABLE, TEMP, TEMPORARY, THEN, TO, TRANSACTION, TRIGGER, UNION, UNIQUE, UPDATE, USING, VACUUM, VALUES, VIEW, WHEN, WHERE, _ROWID_, MAIN, OID, ROWID, SQLITE_MASTER, SQLITE_SEQUENCE, SQLITE_TEMP_MASTER, TEMP

Back to Lookup Files