# Dataset Integer to String Text Conversion

**URL:** <https://forum.inductiveautomation.com/t/dataset-integer-to-string-text-conversion/65835>\
**Category:** Ignition\
**Tags:** vision\
**Created:** [October 29, 2022, 12:34pm UTC](https://forum.inductiveautomation.com/t/dataset-integer-to-string-text-conversion/65835 "2022-10-29T12:34:15Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![neil2](https://avatars.discourse-cdn.com/v4/letter/n/f14d63/32.png) [@neil2](https://forum.inductiveautomation.com/u/neil2)\
**Post date:** [October 29, 2022, 12:34pm UTC](https://forum.inductiveautomation.com/t/dataset-integer-to-string-text-conversion/65835/1 "2022-10-29T12:34:15Z")

</div>

Hi Everyone,  
I am working with a project where I would like to log when the PLC sets or resets an auto request for a device ie a valve open command.  
I have set the tag as a historical tag set to on change. This is working and I can call up a Table component and view the data no problem.  
I would however like the data I see in the table to be changed from say the integer value "1" to a more understandable string value such as "Opened in Auto by PLC". I have been playing around with data sets trying to update values and append but I am wondering if there is an easier way to do this.

Thanks,

---

<div class="post-metadata">

**Author:** ![justinedwards.jle](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/justinedwards.jle/32/37854_2.png) [@justinedwards.jle](https://forum.inductiveautomation.com/u/justinedwards.jle)\
**Post date:** [October 29, 2022, 12:40pm UTC](https://forum.inductiveautomation.com/t/dataset-integer-to-string-text-conversion/65835/2 "2022-10-29T12:40:34Z")

</div>

What kind of table are you using, and is your project Vision or Perspective?

---

<div class="post-metadata">

**Author:** ![neil2](https://avatars.discourse-cdn.com/v4/letter/n/f14d63/32.png) [@neil2](https://forum.inductiveautomation.com/u/neil2)\
**Post date:** [October 29, 2022, 12:54pm UTC](https://forum.inductiveautomation.com/t/dataset-integer-to-string-text-conversion/65835/3 "2022-10-29T12:54:25Z")

</div>

The project is vision and I am using the table component.

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [October 30, 2022, 4:33pm UTC](https://forum.inductiveautomation.com/t/dataset-integer-to-string-text-conversion/65835/4 "2022-10-30T16:33:23Z")

</div>

The table customizer should be able to hande that for you.  
[https://docs.inductiveautomation.com/display/DOC81/Vision+-+Table+Customizer](https://docs.inductiveautomation.com/display/DOC81/Vision+-+Table+Customizer)

---

<div class="post-metadata">

**Author:** ![neil2](https://avatars.discourse-cdn.com/v4/letter/n/f14d63/32.png) [@neil2](https://forum.inductiveautomation.com/u/neil2)\
**Post date:** [October 30, 2022, 4:48pm UTC](https://forum.inductiveautomation.com/t/dataset-integer-to-string-text-conversion/65835/5 "2022-10-30T16:48:00Z")

</div>

How have I never found this before I dont know. Will be trying this out next time I am back on this project.

Thanks