# Power table column translation

**URL:** <https://forum.inductiveautomation.com/t/power-table-column-translation/14704>\
**Category:** Ignition\
**Created:** [July 6, 2017, 6:45pm UTC](https://forum.inductiveautomation.com/t/power-table-column-translation/14704 "2017-07-06T18:45:58Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![brocha](https://avatars.discourse-cdn.com/v4/letter/b/dfb087/32.png) [@brocha](https://forum.inductiveautomation.com/u/brocha)\
**Post date:** [July 6, 2017, 6:45pm UTC](https://forum.inductiveautomation.com/t/power-table-column-translation/14704/1 "2017-07-06T18:45:58Z")

</div>

On the table component there is column translation in the table customizer, but where is the located for the power table? I am using a power table but I need to change an integer to text and have not found where the translation can be done. Any help would be great.

Thanks,  
Brad

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [July 6, 2017, 8:52pm UTC](https://forum.inductiveautomation.com/t/power-table-column-translation/14704/2 "2017-07-06T20:52:13Z")

</div>

Translation for the power table can be accomplished either by changing the incoming data, or with scripting, such as on the configureCell function. You can get a particular columns expected text value and apply whatever formatting you need to.

Take a look at [this KB article](https://support.inductiveautomation.com/index.php?/Knowledgebase/Article/View/109/0/working-with-power-table-extension-functions#configureCell) for more information on using the power table’s extension functions.

---

<div class="post-metadata">

**Author:** ![Sanderd17](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/sanderd17/32/8735_2.png) [@Sanderd17](https://forum.inductiveautomation.com/u/Sanderd17)\
**Post date:** [July 7, 2017, 9:29am UTC](https://forum.inductiveautomation.com/t/power-table-column-translation/14704/3 "2017-07-07T09:29:25Z")

</div>

Combined with the translate function I guess (if you want to use the translation manager): [https://docs.inductiveautomation.com:8443/display/DOC79/system.util.translate](https://docs.inductiveautomation.com:8443/display/DOC79/system.util.translate)

---

<div class="post-metadata">

**Author:** ![brocha](https://avatars.discourse-cdn.com/v4/letter/b/dfb087/32.png) [@brocha](https://forum.inductiveautomation.com/u/brocha)\
**Post date:** [July 7, 2017, 2:45pm UTC](https://forum.inductiveautomation.com/t/power-table-column-translation/14704/4 "2017-07-07T14:45:13Z")

</div>

Thanks, got it working.

---

<div class="post-metadata">

**Author:** ![gpellicelli](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/gpellicelli/32/53466_2.png) [@gpellicelli](https://forum.inductiveautomation.com/u/gpellicelli)\
**Post date:** [April 20, 2020, 4:32pm UTC](https://forum.inductiveautomation.com/t/power-table-column-translation/14704/5 "2020-04-20T16:32:24Z")

</div>

If the textValue is on your translation manager you this code will translate your cell text you just need to put this script in Extension Functions configureCell of your power table:

# This Section is for Translate the text value of the cell

```
Translate = system.util.translate(textValue)
if not textValue == "":
	return {'text' : Translate}
```