Adding Or Editing A Lookup Table
A Lookup Table creates a connection between a set of values in your source data and the associated values in your target. Lookup Tables can also be imported from a CSV file or exported to a CSV. This can be useful if your Lookup data already exists in another TIBCO Scribe® Online Organization or some other program. See Importing Or Exporting Lookup Tables.
Before you begin, make sure you know what values you plan to map in both your source and target data sources.
- From the Menu, select More > Lookup Tables.
- From the Lookup Tables page, select Add
to create a new Lookup table. TIBCO Scribe® Online creates an empty Lookup Table and opens the Edit Lookup Table dialog. 
- Modify the name for this Lookup Table, and optionally, enter a description. Only alphanumeric characters, underscore, and dash are supported in these two fields.
Note: Consider using the Description field to call out the entities and fields you are using for this Lookup table.
- From the Menu
, select Create. Under the Value 1 and Value 2 columns, blank table cells display at the bottom of the list. - Select the Value 1 field and enter an existing value for the field you want to map in the source entity.
- Select the Value 2 field and enter the associated field value for the target entity field.
- Select Create again to create additional rows in the Lookup Table.
- When you have finished the table, select Close. Changes to the Lookup Table are saved as they are entered.
You can now use your Lookup Table with any of the LOOKUPTABLEVALUE functions.
Note: To allow the Lookup Table to map fields that contain either an empty string or a NULL, you can use an empty string. A NULL value in the Lookup Table is translated to the string "NULL".
Tip: While Lookup Tables are most often used to map a set of values between your source and target entities, you can use them to provide mappings between any two sets of values in your data.
