2.2.2 Source and Lookup Selection Pane

Select a Source table and a Lookup table. The source table list is limited to the instrument tables under PBSMCS. The tables available in the Lookup drop-down list are limited to lookup tables that have been created through the Lookup Table user interface.

Click on the ‘View Data’ button to invoke the ‘Lookup Table Data’ window that displays the lookup table columns and the data contained in the lookup table. The actual columns of the Table Data depend on the Lookup Table selected.

Figure 2-5 Source and Lookup Tables Pane


Select a Source instrument table and a Lookup table. The tables available in the Lookup drop-down list are limited to tables that you have registered as Lookup Tables within your data model.

The Lookup Table Data screen allows several operations on the selected lookup table data.

  • Click the Add icon to add a new row to the Lookup table.

    A new row is added. Enter the values for the row and click Save.

  • Click the Delete icon to delete a row(s) from the Lookup table.
  • Click the Export or the Import icons to access the Export or Import functionality. While exporting, the data from this screen is exported as a .xls file.

Figure 2-6 Lookup Table Data Screen


The Lookup Table Data Information screen displays the Lookup Tamplate table. You can Add or Delete a new row, Export or Import the table data, sort ro clear sorts.