# Convert a single register in to a table of Assets states

**URL:** <https://forum.inductiveautomation.com/t/convert-a-single-register-in-to-a-table-of-assets-states/80638>\
**Category:** Ignition\
**Created:** [October 18, 2023, 12:21pm UTC](https://forum.inductiveautomation.com/t/convert-a-single-register-in-to-a-table-of-assets-states/80638 "2023-10-18T12:21:03Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gavin\_Bentley](https://avatars.discourse-cdn.com/v4/letter/g/8c91f0/32.png) [@Gavin\_Bentley](https://forum.inductiveautomation.com/u/Gavin_Bentley)\
**Post date:** [October 18, 2023, 12:21pm UTC](https://forum.inductiveautomation.com/t/convert-a-single-register-in-to-a-table-of-assets-states/80638/1 "2023-10-18T12:21:03Z")

</div>

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/2/b238c34bd5ea9695760948eab373d9c2be192e18.png)

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 ?

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [October 18, 2023, 12:26pm UTC](https://forum.inductiveautomation.com/t/convert-a-single-register-in-to-a-table-of-assets-states/80638/2 "2023-10-18T12:26:04Z")

</div>

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()](https://docs.inductiveautomation.com/display/DOC81/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.

---

<div class="post-metadata">

**Author:** ![Gavin\_Bentley](https://avatars.discourse-cdn.com/v4/letter/g/8c91f0/32.png) [@Gavin\_Bentley](https://forum.inductiveautomation.com/u/Gavin_Bentley)\
**Post date:** [October 18, 2023, 12:38pm UTC](https://forum.inductiveautomation.com/t/convert-a-single-register-in-to-a-table-of-assets-states/80638/3 "2023-10-18T12:38:33Z")

</div>

Thank you
