Creating a lookup table
Available from version 8.3 and later.
You need the MANAGE_LOOKUP_TABLES privilege and the lookup tables feature in your license.
Create the table
- Click Lookup tables in the main menu.
- Click Create lookup table.
- Enter a Name (unique within the organization) and, optionally, a Description.
- Under Add column, enter a Column name, choose its type (String, Number or Boolean) and click the plus button. Repeat for every column.
- Use the arrow buttons to change the order of the columns, and the delete button to remove one.
- Click Save.
A table needs at least one column. The column names row and params are reserved.
After saving, the table opens on its Table tab.
Add and edit rows
- Select the lookup table and click Edit.
- On the Table tab, click Add row.
- Double-click a cell, or select it and start typing, to enter a value. A Boolean cell is a checkbox.
- Click Save to write all changes at once, or Cancel to discard them.
Changes to rows are not saved until you click Save. Until then, the table shows a notice that row changes are not saved yet.
Change the columns
Click Edit and open the Settings tab.
- Rename a column: change its name. The column keeps its values.
- Add a column: use Add column. The new column is empty in every row.
- Remove a column: click its delete button. Historian asks you to confirm. Its values are cleared from every row when you save.
For a manual table, the type of a saved column cannot be changed. On a synced table you can change it, see Syncing a lookup table from an external database. To change it on a manual table, export the table and import the file again with the new column type (see Importing and exporting a lookup table).
Delete a lookup table
Select the lookup table and click Delete at the bottom of the panel.
The delete dialog lists every resource that depends on the table, directly or through another resource. Type the name of the lookup table to confirm. Confirming deletes the table and all of them. The Referenced by section on the Settings tab lists what uses the table.