Convert a single register in to a table of Assets states


I would like to display the text in the table attached depending on what the value of the register is e.g 0=Display Off , 1=Remote Off etc....

What is the best way to do this ?

Typically, you'd create a two-column dataset in a memory tag containing all of the values and corresponding strings. Then, wherever you need to display the string, use Ignition's lookup() function in an expression binding.

If you are storing these values in a database, you might consider also creating a reference table in that DB with the same structure, to be used with DB JOINs.

Thanks you