Live Data grid - Live Data Lookup view

The Live Data Lookup view is used to specify lookup tables that allow translation of external values coming from telemetry databases into internal values that will be correctly interpreted by InfoWorks WS Pro or IWLive Pro.

The view is opened by double-clicking a live data configuration object in the Model Group window, then clicking the Live Data Lookup tab.

ClosedShow image

Live Data Lookup tab

Notes:

Item Description
Left-most column

If clicked, selects the whole row.

A forward triangle indicates the current row.

An asterisk indicates where a new object can be created by entering its details (in this case, by entering a lookup name).

Fields

Lookup Name

User name for the lookup table. Lookup tables can be enabled for feeds in the Live Data Feed view.

Lookup Type

Type of the lookup:

  • Scalar - translates value A to value B
  • Range - translates a range of values to value B

Default Value

Optional.

Value used when there is no match for the external value.

If a default value is not set, a null value will be returned when there is no match for the external value.

Lookup

Clicking the ellipsis button displays theLive Data Lookup Editor.

Mapping or translation lists are entered in the editor, allowing external values provided by telemetry databases to be translated into values for use in InfoWorks WS Pro or IWLive Pro.

Context menu option

The Live Data Lookup Editor can be displayed by right-clicking a completed row, then selecting Lookup.


Live Data grid

About live data

Live Data Lookup Editor

Live Data grid - Live Data Logon view

Live Data grid - Live Data Feed view

Live Data grid - Live Data Export view

Open Data Import Centre dialog