# Show 2 digit float value for all the column in powertable

**URL:** <https://forum.inductiveautomation.com/t/show-2-digit-float-value-for-all-the-column-in-powertable/75373>\
**Category:** Ignition\
**Tags:** vision\
**Created:** [June 22, 2023, 4:08am UTC](https://forum.inductiveautomation.com/t/show-2-digit-float-value-for-all-the-column-in-powertable/75373 "2023-06-22T04:08:32Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![prasath.t](https://avatars.discourse-cdn.com/v4/letter/p/898d66/32.png) [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\
**Post date:** [June 22, 2023, 4:08am UTC](https://forum.inductiveautomation.com/t/show-2-digit-float-value-for-all-the-column-in-powertable/75373/1 "2023-06-22T04:08:32Z")

</div>

Hi guys,  
I have power table where **i have nearly 15 columns**. **i want to show 2 digit after decimal val** ue

its is possible i adding **every column name in column attributes**. But column name will be changing dynamically

Is there any alternative way to fix it?

can we able to fix this through scripting?

---

<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:** [June 22, 2023, 12:28pm UTC](https://forum.inductiveautomation.com/t/show-2-digit-float-value-for-all-the-column-in-powertable/75373/2 "2023-06-22T12:28:51Z")

</div>

Yes, you need to generate the entire `columns` property dynamically. This is usually easiest if the source data is in dataset format (so column names are available, in order, and data types are available) in a custom property. You might find this comment helpful:

> [@Automation Professionals' Integration Toolkit Module](https://forum.inductiveautomation.com/t/automation-professionals-simulation-aids-v2/74934/5):
>
> I have spent my holiday poking at this. Wanted to provide an efficient replacement for a common use of python transforms: Make a (Perspective) table that dynamically populates both .data and .columns from source dataset that isn't constrained to any particular structure or data types. In Vision, one can achieve this (mostly) by pre-populating the column attributes dataset with all of the possible column names your application might deliver. No such thing in Perspective. But a transform can …

In addition to showing off the performance of the new features of my free module, it has a skeleton of the kind of scripting you need.

---

<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:** [July 5, 2023, 5:10am UTC](https://forum.inductiveautomation.com/t/show-2-digit-float-value-for-all-the-column-in-powertable/75373/3 "2023-07-05T05:10:48Z")

</div>

Out of curiosity, how is your table being populated?

---

<div class="post-metadata">

**Author:** ![prasath.t](https://avatars.discourse-cdn.com/v4/letter/p/898d66/32.png) [@prasath.t](https://forum.inductiveautomation.com/u/prasath.t)\
**Post date:** [July 5, 2023, 12:50pm UTC](https://forum.inductiveautomation.com/t/show-2-digit-float-value-for-all-the-column-in-powertable/75373/4 "2023-07-05T12:50:35Z")

</div>

Hi from database through named query