Skip to main content

Create and use lookup tables

Converting columns to numbers

Empty and non-numeric cells remain empty instead of becoming 0. Review filters and expressions that distinguish empty values from a numeric zero after converting a column.

Settings guide

Keep small, controlled reference datasets in NIM and make them available to your data model.

Create a lookup tableDirect link to Create a lookup table

Build a lookup table

Add the tableDirect link to Add the table

Go to Configuration > Settings > Lookup Tables. In Tables, select Add, enter a table name, and select Add.

Step 1 of 5

For a provisioning example, see Preserve and reuse legacy usernames, which uses a lookup table to store username and email history.