Create Lookup Formula/Script

[WayneS]

Greetings. I would like to create a formula or script that operates in a similar way to the lookup function in excel. Essentially I have a value from 0-255 where each value menas something different, i.e.
0= Normal operation
1= Engine Fault
2= Generator fault … to 255=overtemperature.

Many thanks

• This topic was modified 2 months, 3 weeks ago by WayneS.

[JW]

for fewer values, you can create a new format as eum.
e.g.
create a new row in format table,
MyFormat, enable “is Enum”, enter “Normal operation;Generator fault”
config the channel
MyCnl, selelct “MyFormat” as format
Then when the value is 0, will display Normal operation, when is 1, will display Generator fault.

but for 256 values, maybe better use a script to convert the number to string.
e.g.
keep the original channel and value Cnl 101
create a new channel as converted string Cnl 102, enable input formula, set the formula as Val2String(101)
and you need to define the Val2String() function by creating a new row on the Script table

[Mikhail]

Hi,
As an example, open the Formats table ach check the Off-On format.
If you have many values in an enumeration, it’s supported to text each value per line.

[WayneS]

Thanks, That all makes sense 🙂

[Author]

Posts